MySQL (5.6) drop table tab1;create table tab1(col1 int,col2 varchar(100),col3 timestamp);alter table tab1 add constraint tab1pk primary key(col1); : > a.sql echo "truncate table tab1;" >> a.sqlecho "insert into tab1 values " >> a.sqlecho "…

MySQL https://gihyo.jp/dev/serial/01/mysql-road-construction-news/0117(8.0) drop table tab1;drop table tab2; create table tab1(col1 int);create table tab2(col1 int); drop procedure proc1; delimiter //create procedure proc1()begin declare i…

MySQL (5.6)調べた限りない模様 Oracle (12cR1) https://www.drk7.jp/MT/archives/001578.html -- 1.準備 drop table tab1 purge;create table tab1(col1 int,col2 varchar2(10)); create index ind1 on tab1(col1,col2); declarebegin for i in 1..100 loop…