06_DB SQL – シェルでDB
MariaDBのサービス起動チェック
#!/bin/sh
## -------------------------------------------------------------------------
## Script...
06_DB
06_DB 06_DB SQL – stored procedure
通常-oracle
SQL> create or replace procedure sample_proc(v_id in char,v_name out varchar2) as
2 begin
3 dbms...
06_DB SQL – transaction
mysql / mariadb
START TRANSACTION;
SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
UPDATE table2 SET summary=@A WHE...
06_DB SQL – update / delete
通常update
$StrSQL =
"update GVIS_zaiko " . "\n"
. " set GVIS_No = '" . $mysqli->real_escape_string($...
06_DB SQL – insert
通常insert
$StrSQL =
"insert into GVIS_log "
. " ( logPeriod,"
. " logShubetsu, "
. " clientI...