删除mysql表中的重复数据

DELETE FROM pre_table WHERE id in (
SELECT b.id FROM pre_table b
INNER JOIN (SELECT title, COUNT(1) total, MIN(id) as mid FROM pre_table GROUP BY title ORDER BY total desc ) t on t.title = b.title
WHERE t.total>1 AND b.id != t.mid
)

版权属于：Joyber

本文链接：https://blog.qqvbc.com/default/291.html

转载时须注明出处及本声明