无限星辰工作室-客户无限互联网动力之源

标题: Discuz!x3.2 批量清理短信内容 [打印本页]

---

作者: crx349    时间: 2014-8-17 01:01
标题: Discuz!x3.2 批量清理短信内容
Discuz!x3.2 用久了（特别是一个版本一个版本升级上来的） 短信内容容易堆积导致 数据库缓慢 可以使用以下句子 清理下 无效短信：

1. DELETE FROM `pre_ucenter_pm_messages_1` WHERE `delstatus`='1' or `delstatus`='2';
   
2. DELETE FROM `pre_ucenter_pm_messages_2` WHERE `delstatus`='1' or `delstatus`='2';
   
3. DELETE FROM `pre_ucenter_pm_messages_3` WHERE `delstatus`='1' or `delstatus`='2';
   
4. DELETE FROM `pre_ucenter_pm_messages_4` WHERE `delstatus`='1' or `delstatus`='2';
   
5. DELETE FROM `pre_ucenter_pm_messages_5` WHERE `delstatus`='1' or `delstatus`='2';
   
6. DELETE FROM `pre_ucenter_pm_messages_6` WHERE `delstatus`='1' or `delstatus`='2';
   
7. DELETE FROM `pre_ucenter_pm_messages_7` WHERE `delstatus`='1' or `delstatus`='2';
   
8. DELETE FROM `pre_ucenter_pm_messages_8` WHERE `delstatus`='1' or `delstatus`='2';
   
9. DELETE FROM `pre_ucenter_pm_messages_9` WHERE `delstatus`='1' or `delstatus`='2';
   
10. DELETE FROM `pre_ucenter_pm_messages_0` WHERE `delstatus`='1' or `delstatus`='2';

复制代码

---

欢迎光临 无限星辰工作室-客户无限互联网动力之源 (https://xmspace.net/)

Powered by Discuz! X3.4