delete table1,table2 from table1 ,table2 where table1.id = table2.id and table1.type = 'music' ------解决方案-------------------- 检查一下索引情况,在ID上有索引? ------解决方案--------------------
------解决方案--------------------
SQL code
create table delete_id as select table1.id from table1 inner join table2 on table1.id = table2.id where table1.type = 'music'; create index indx1 on delete_id(id); delete from table1 where id in(select id from delete_id); delete from table2 where id in(select id from delete_id); ------解决方案--------------------