DELETE
FROM
test_name
WHERE
`name` IN (
SELECT
`name`
FROM (
SELECT `name` FROM test_name GROUP BY `name` HAVING COUNT(`name`) > 1
) a
)
AND
`id` NOT IN (
SELECT
`id`
FROM (
SELECT min(`id`) AS `id` FROM test_name GROUP BY `name` HAVING count(`name`) > 1
) b
);
Mysql 中删除重复的数据并只保留一条
最新推荐文章于 2024-08-07 14:51:18 发布