1
drop table if exists t1;
2
set session transaction isolation level read committed;
3
create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1;
4
create table t2 like t1;
5
insert into t2 values (1),(2),(3),(4),(5),(6),(7);
8
replace into t1 select * from t2;
9
set session transaction isolation level read committed;
11
delete from t2 where a=5;
17
insert into t1 select * from t2;
18
set session transaction isolation level read committed;
20
delete from t2 where a=5;