MySQL (8.0.22) select @@secure_file_priv; drop table tab1;drop table tab2; create table tab1(col1 int primary key,col2 int);create table tab2(col1 int primary key); insert into tab1 values(1,100);insert into tab1 values(2,200);insert into …

MySQL 調べた限り未対応 Oracle (12cR1) -- 設定 conn / as sysdbadrop flashback archive fla1;create flashback archive default fla1 tablespace users quota 1G retention 1 month; select * from dba_flashback_archive;select * from dba_flashback_ar…

MySQL (8)https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlock-detection.html 小さいトランザクションがロールバックされる InnoDB tries to pick small transactions to roll back, where the size of a transaction is determined by the number of…