06_DB SQL – シェルでDB MariaDBのサービス起動チェック #!/bin/sh ## ------------------------------------------------------------------------- ## Script... 2022.03.05 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... 2022.03.05 06_DB
06_DB SQL – transaction mysql / mariadb START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHE... 2022.03.05 06_DB
06_DB SQL – update / delete 通常update $StrSQL = "update GVIS_zaiko " . "\n" . " set GVIS_No = '" . $mysqli->real_escape_string($... 2022.03.05 06_DB
06_DB SQL – insert 通常insert $StrSQL = "insert into GVIS_log " . " ( logPeriod," . " logShubetsu, " . " clientI... 2022.03.05 06_DB