爱就爱了

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 10310|回复: 0

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

[复制链接]
发表于 2011-5-1 00:09:24 | 显示全部楼层 |阅读模式
discuz7.2的语句

  1. delete from cdb_threads  where displayorder=-2;
  2. delete from cdb_posts  where invisible=-2;
复制代码


discuz x1.0的语句

  1. delete from pre_forum_thread where displayorder=-2;
  2. delete from pre_forum_post where invisible=-2;
  3. delete from pre_forum_thread  where `displayorder` = '-1';
复制代码


x1的最后一句是删回收站的。
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

小黑屋|手机版|Archiver|平龙认个人分站 - 爱就爱了 ( 豫ICP备14029057号-2、4、5 )
豫公网安备 41010502002156号

GMT+8, 2024-11-21 23:53 , Processed in 0.093411 second(s), 19 queries , Gzip On.

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表