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 )
- 周五. 4月 26th, 2024
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 )