MySQL 多字段联合去重删除重复数据保留id最小的一条

DELETE FROM 表名 WHERE (字段1,字段2,字段3)
IN 
(SELECT 字段1,字段2,字段3 FROM (SELECT 字段1,字段2,字段3 FROM 表名 GROUP BY 字段1,字段2,字段3 HAVING COUNT(*)>1) s1) 
AND
id NOT IN (SELECT id FROM (SELECT min(id) as id FROM 表名 GROUP BY 字段1,字段2,字段3 HAVING COUNT(*)>1) s2);

 

参考 https://www.cnblogs.com/XiaoMingBlingBling/p/11146375.html 修改最后一个子查询中的 id 为 min(id) as id