Mysql的sql语句，Delete 中包含 not in

DELETE FROM tb_tableA WHERE id IN ( 2 SELECT a.id FROM tb_tableA a WHERE a.id NOT IN ( 3 SELECT a_id FROM tb_tableB 4 ) 5 ); mysql delete not in 示例

是无法正确执行的。

解决方案：创建临时表，作为中间表；用完再删去。

1 CREATE TABLE tmp AS SELECT a.id FROM (
2         SELECT a.id FROM tb_tableA a WHERE a.id NOT IN ( 
3                 SELECT a_id FROM tb_tableB 
4         ) 
5 ) a;
6 DELETE FROM tb_tableA WHERE id IN (SELECT id FROM tmp); 
7 DROP TABLE tmp;

用中间表存储需要删除的数据

成功！

 

Mysql的sql语句，Delete 中包含 not in

标签：style   tmp   opened   span   src   col   数据   成功   cli