删除表重复数据

delete from crawler_news where id not in (select id from (select id from crawler_news group by url) tt)

原文地址:https://www.cnblogs.com/lvfeilong/p/234sfdf.html