• 周一. 4月 22nd, 2024

5G编程聚合网

5G时代下一个聚合的编程学习网

热门标签

mysql删除重复数据只保留一条

admin

11月 28, 2021
delete from toutiao where title in (SELECT a.title from

(select title from toutiao group by title

having count(title) > 1) a

)and id not in (SELECT b.id from (select id from toutiao group by title having count(title) > 1) b

)

  

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注