天狼晓月 发表于 2011-5-1 00:09:24

discuz7.2与discuz x1.0批量删除待审核的帖子的SQL语句

discuz7.2的语句

delete from cdb_threadswhere displayorder=-2;
delete from cdb_postswhere invisible=-2;


discuz x1.0的语句

delete from pre_forum_thread where displayorder=-2;
delete from pre_forum_post where invisible=-2;
delete from pre_forum_threadwhere `displayorder` = '-1';


x1的最后一句是删回收站的。
页: [1]
查看完整版本: discuz7.2与discuz x1.0批量删除待审核的帖子的SQL语句