06_DBSQL – stored procedure
通常-oracleSQL> create or replace procedure sample_proc(v_id in char,v_name out varchar2) as 2 begin 3 dbms_output.pu...
2022-03
06_DB 06_DBSQL – transaction
mysql / mariadbSTART TRANSACTION;SELECT @A:=SUM(salary) FROM table1 WHERE type=1;UPDATE table2 SET summary=@A WHERE type...
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）とは、結合...