MySQL (5.6)対応していない (8.0)※ recursiveが必要 with recursive t1(col1) as(select 1union allselect col1+1from t1where col1+1 <= 100)select col1 from t1; Oracle (12cR1) https://www.oracle.com/technetwork/jp/articles/otnj-sql-image7-1525406…

MySQL (5.6)drop table tab1;create table tab1(col1 int not null,col2 int,col3 char(100)); drop procedure proc1; delimiter //create procedure proc1()begin declare i int; declare j int; declare k int; set i = 1; set j = 1; set k = 1; while i …

MySQL (5.6) drop table tab1;create table tab1(col1 int not null,col2 int,col3 char(100)); drop procedure proc1; delimiter //create procedure proc1()begin declare i int; declare j int; declare k int; set i = 1; set j = 1; set k = 1; while i …