DELETE
a
FROM
user1 a
JOIN (
SELECT
user_name,
count(*),
MAX(id) AS id
FROM
user1
GROUP BY
user_name,over
HAVING
COUNT(*) > 1
) b ON a.user_name = b.user_name
WHERE
a.id < b.id
MySQL删除重复数据 并保留ID最大值
最新推荐文章于 2024-05-16 09:35:14 发布