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...
06_DB
06_DB 06_DBSQL – transaction
mysql / mariadb START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE t...
06_DBSQL – update / delete
通常update $StrSQL = "update GVIS_zaiko " . "\n" . " set GVIS_No = '" . $mysqli->real_escape_string($InputParm_GVIS_No) . ...
06_DBSQL – insert
通常insert $StrSQL = "insert into GVIS_log " . " ( logPeriod," . " logShubetsu, " . " clientIP, " . " userID, " . " Sousa,...
06_DBSQL – select
データ取り出し例 select * from table ; 重複なしのデータ取り出し例 SELECT distinct Sousa FROM GVIS_log order by Sousa ; 内部結合 内部結合（INNER JOIN）と...