数据库删除discuz 部分数据操作

如何快速清理discuz 3.2 中等待审核的回复数：pre_forum_post_moderate，点击清空

清空回收站的主题帖：DELETE FROM `pre_forum_thread` WHERE `displayorder` = -1
清空回收站回帖：DELETE FROM `pre_forum_post` WHERE `invisible` = -5
清空回收站日志：DELETE FROM `pre_home_blog` WHERE `status` = -1

批量删除DZ论坛中未审核的垃圾贴
delete from pre_forum_thread where displayorder=-2;
delete from pre_forum_post where invisible=-2;

数据库删除discuz 部分数据操作

原文：http://www.cnblogs.com/coolid/p/7825718.html