mysql 删除重复数据

2019独角兽企业重金招聘Python工程师标准>>>

DELETE FROM 表0 WHERE id NOT IN ( select id from ( SELECT id FROM 表0 GROUP BY 字段0, 字段1) t );

转载于:https://my.oschina.net/jingshishengxu/blog/1920581