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中寫入回數據庫

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈