批量删除垃圾帖

先查询一下与后台的未审核的主题数是否一致
SELECT count( * )
FROM `表前缀_threads`
WHERE displayorder = -2;
批量删除未审核的主题
delete from 表前缀_threads where displayorder=-2;
先查询一下与后台的未审核的回复数是否一致
SELECT count( * )
FROM `表前缀_threads`
WHERE displayorder = -2;

批量删除未审核的回复
delete from 表前缀_posts where invisible=-2;

 

SELECT count( * ) FROM cdb_threads WHERE displayorder = -2;
delete from cdb_threads where displayorder=-2;

转载于:https://www.cnblogs.com/maxthon/archive/2011/12/22/2298699.html