MySql中不能在delete语句中使用select语句(同一张表),所以下面的sql会报错
DELETE FROM table_name WHERE id IN (SELECT_SQL)
解决办法:
CREATE TABLE tmp_table_name AS SELECT_SQL;--创建一张临时表
DELETE FROM tabla_name WHERE id IN (SELECT id FROM tmp_table_name );--删除数据
DROP TABLE tmp_table_name ;--删除临时表