请事先备份数据库
后台执行如下Sql语句即可。create table bak as (select * from cdb_threads group by subject having count(*)=1);
insert into bak (select * from cdb_threads group by subject having count(*)>1);
truncate table cdb_threads;
insert into cdb_threads select * from bak;