mysql 根据多字段去重 --效率高

模板

释义：根据多字段去重，保留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
)