1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
drop table if exists t1; create table t1 (a int) engine=innodb; start transaction with consistent snapshot; insert into t1 values(1); select * from t1; a commit; delete from t1; start transaction; insert into t1 values(1); select * from t1; a 1 commit; drop table t1; |