MySQL 根据多个字段 删除重复记录 只保留最小id的记录 源码 MySQL 根据多个字段 删除多余的重复记录(多个字段),只保留最小id的记录 源码 亲测有效 ``` DELETE FROM mails WHERE id IN ( SELECT * FROM ( SELECT id FROM mails WHERE ( mails_id, users_id) IN ( SELECT mails_id, users_id FROM mails GROUP BY mails_id, users_id HAVING COUNT(1) > 1 ) AND id NOT IN ( SELECT MIN(id) FROM mails GROUP BY mails_id, users_id HAVING COUNT(1) > 1 ) ) AS stu_repeat_copy ); ```
《MySQL 根据多个字段 删除重复记录 只保留最小id的记录 源码》上暂无评论!