DELETE FROM s_dict WHERE id IN (
select * from ( ( select id from s_dict where name in (select name from s_dict group by name having count(name)>1))) a
)
AND id NOT IN (
select * from ((SELECT min(t.id) FROM s_dict t GROUP BY t.name HAVING count(t.name) > 1)) b)
;
一条sql删除重复表重复记录
最新推荐文章于 2023-08-01 22:00:00 发布