DELETE t1 FROM test_copy t1
INNER JOIN (
SELECT title, content, MAX(id) AS max_id
FROM test_copy
GROUP BY title, content
HAVING COUNT(*) > 1
) t2 ON t1.title = t2.title AND t1.content = t2.content AND t1.id < t2.max_id;
mysql清理表中重复数据
最新推荐文章于 2024-07-16 08:19:13 发布