模板
释义:根据多字段去重,保留ID最小的记录
DELETE from 表名
WHERE id not in(
SELECT t.min_id from (SELECT MIN(id) as min_id from 表名 GROUP BY 字段1, 字段2, 字段N) t
)
案例
删除用户动态中用户名和发布时间相同的记录(用户名和发布时间一样,则认为是重复记录)
DELETE from user_dongtai_xc
WHERE id not in(
SELECT min_id from (SELECT MIN(id) as min_id from user_dongtai_xc GROUP BY 用户名, 发布时间) t
)