DELETE FROM 表1
WHERE ( 字段1,字段2 ) IN( SELECT 字段1,字段2 FROM 表1
GROUP BY 字段1,字段2 HAVING COUNT(*) >1)
AND id NOT IN(SELECT MIN(id)
FROM 表1
GROUP BY 字段1,字段2HAVING COUNT(*) >1)
DELETE FROM 表1
WHERE ( 字段1,字段2 ) IN( SELECT 字段1,字段2 FROM 表1
GROUP BY 字段1,字段2 HAVING COUNT(*) >1)
AND id NOT IN(SELECT MIN(id)
FROM 表1
GROUP BY 字段1,字段2HAVING COUNT(*) >1)
本文标题：MySQL删除重复数据,只保留最早一条
本文链接：https://www.haomeiwen.com/subject/ookjbctx.html
网友评论