兔源码_免费的Discuz模板|插件|素材|建站资源下载

 找回密码
 立即注册

QQ登录

只需一步,快速开始

返回列表 

discuz运营一些常用sql语句

[复制链接]

欢迎加入兔源码站长交流群,您的加入是我们前行的动力!

DZ站长建站交流群:493651246

[ 温馨提示:点击上方群文字,可快速加入QQ群 ]

清零所有附件下载次数
  1. UPDATE pre_forum_attachment SET downloads = 0
复制代码

清零所有附件下载用户记录
同:清空所有用户的积分变化的记录

清零所有帖子的访问次数
  1. UPDATE pre_forum_thread SET views = 0
复制代码

清空所有用户的积分变化的记录【不是把所有用户的积分变成0,只是每次积分变化的记录】
  1. DELETE FROM pre_common_credit_log
复制代码

清空所有系统提醒消息
  1. DELETE FROM pre_home_notification
复制代码

清空所有站内短消息
  1. DELETE FROM `pre_ucenter_pm_lists` WHERE 1 ;
  2. DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
  3. DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
  4. DELETE FROM `pre_ucenter_pm_messages_0` WHERE 1 ;
  5. DELETE FROM `pre_ucenter_pm_messages_1` WHERE 1 ;
  6. DELETE FROM `pre_ucenter_pm_messages_2` WHERE 1 ;
  7. DELETE FROM `pre_ucenter_pm_messages_3` WHERE 1 ;
  8. DELETE FROM `pre_ucenter_pm_messages_4` WHERE 1 ;
  9. DELETE FROM `pre_ucenter_pm_messages_5` WHERE 1 ;
  10. DELETE FROM `pre_ucenter_pm_messages_6` WHERE 1 ;
  11. DELETE FROM `pre_ucenter_pm_messages_7` WHERE 1 ;
  12. DELETE FROM `pre_ucenter_pm_messages_8` WHERE 1 ;
  13. DELETE FROM `pre_ucenter_pm_messages_9` WHERE 1 ;
复制代码

版权声明
1、转摘或引用本站内容资源须注明原网址,并标明本站网址(兔源码www.tuyuanma.com);
2、对于转摘或引用本站内容资源而引起的民事纠纷、行政处罚或其他损失,本站不承担责任;
3、对于不遵守本声明或其他违法、恶意使用本站内容者,本站保留其追究法律责任的权利。



493651246站长邮箱:tuyuanma@qq.com 站长QQ:3197813386

© 2015-2021 本站内容皆来自互联网及用户分享,如需删除请提供软著或商标证书。

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