错误:不能在同一表中删除和查询数据
DELETE
FROM
hotsearch
WHERE
wz IN ( SELECT wz FROM hotsearch WHERE wz LIKE '%菲律宾%' OR wz LIKE '%越南%' );
正确:查询条件前面再写一遍 SELECT XXX FROM ( SELECT XXX FROM 表名 。。。)a
DELETE
FROM
hotsearch
WHERE
wz IN ( SELECT wz FROM ( SELECT wz FROM hotsearch WHERE wz LIKE '%菲律宾%' OR wz LIKE '%越南%' ) a );