53
53
connection default;
58
create table t1 (a int, b int) engine=myisam;
59
create table t2 (c int, d int, key (c)) engine=innodb;
60
insert into t1 values (1,1);
61
insert into t2 values (1,2);
62
connect (a,localhost,root,,);
64
set session transaction isolation level read committed;
65
delete from t1 using t1 join t2 on t1.a = t2.c where t2.d in (1);