蓝雨 发表于 2009-3-2 22:53:18

快速删除重复标题,相同主题插件

请事先备份数据库

后台执行如下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;
页: [1]
查看完整版本: 快速删除重复标题,相同主题插件