Discuz! 批量删除重复主题SQL语句,简易插件

请事先备份数据库

经测试执行后必要更新缓存，不然发新帖子有题目

靠山执行如下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;
--------------------------------------------------------------------

此Sql语句可以删除任何的一再数据，赤色部门为表名 绿色部门为字段值

注释版：

create table bak as (select * from cdb_threads group by subject having count(*)=1);
新建bak 然后把帖子没有一再的写进去
insert into bak (select * from cdb_threads group by subject having count(*)>1);
然后再把不止一条，也就是一再的也写入
truncate table cdb_threads;
删除
insert into cdb_threads select * from bak;
把文件从BAK中写入回数据库

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!