06_DBSQL – stored procedure 通常-oracle SQL> create or replace procedure sample_proc(v_id in char,v_name out varchar2) as 2 begin 3 dbms_output... 2022.03.0506_DB
06_DBSQL – transaction mysql / mariadb START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE t... 2022.03.0506_DB
06_DBSQL – update / delete 通常update $StrSQL = "update GVIS_zaiko " . "\n" . " set GVIS_No = '" . $mysqli->real_escape_string($InputParm_GVIS_No) . ... 2022.03.0506_DB
06_DBSQL – insert 通常insert $StrSQL = "insert into GVIS_log " . " ( logPeriod," . " logShubetsu, " . " clientIP, " . " userID, " . " Sousa,... 2022.03.0506_DB
06_DBSQL – select データ取り出し例 select * from table ; 重複なしのデータ取り出し例 SELECT distinct Sousa FROM GVIS_log order by Sousa ; 内部結合 内部結合(INNER JOIN)と... 2022.03.0506_DB