示例表 users
id name
1 a
2 a
3 b
4 c
5 c
6 c
7 d
语句:
DELETE FROM users
WHERE name in
(SELECT name from
(SELECT name from
users GROUP BY name
HAVING COUNT(name)>1)
a)
and id not in(SELECT id
from (SELECT id from
users GROUP BY name
HAVING COUNT(name)>1)
b)
mysql删除重复元素示例
最新推荐文章于 2022-08-02 01:05:19 发布