41
create table t1 (a int, b int) engine=myisam;
42
create table t2 (c int, d int, key (c)) engine=innodb;
43
insert into t1 values (1,1);
44
insert into t2 values (1,2);
45
set session transaction isolation level read committed;
46
delete from t1 using t1 join t2 on t1.a = t2.c where t2.d in (1);