Discuz! 批量刪除重復主題SQL語句,簡易插件

請事先備份數(shù)據(jù)庫

經(jīng)測試執(zhí)行后需要更新緩存，否則發(fā)新帖子有問題

后臺執(zhí)行如下Sql語句即可。建議在網(wǎng)絡比較暢快的時候使用，數(shù)據(jù)庫過大不建議使用
不過重復帖子一般源于采集，呵呵

---------------------------------------------------------------
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語句可以刪除任何的重復數(shù)據(jù)，紅色部分為表名 綠色部分為字段值

注釋版：

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中寫入回數(shù)據(jù)庫

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