DELETE FROM jingpintuji WHERE id IN ( select id from(SELECT id FROM jingpintuji WHERE
if_download = 0 GROUP BY url HAVING count(id) > 1) its )
删除jingpintuji里 if_download = 0的url重复记录
通常我们这样写
DELETE FROM jingpintuji WHERE id IN (
SELECT id FROM jingpintuji WHERE
if_download = 0 GROUP BY url HAVING count(id) > 1 )
但是发现mysql会报错,[Err] 1093 - You can’t specify target table ‘jingpintuji’ for update in FROM clause
这个时候需要借助于中间表处理。