Discuz!x3.2 批量清理短信内容
Discuz!x3.2 用久了（特别是一个版本一个版本升级上来的） 短信内容容易堆积导致 数据库缓慢 可以使用以下句子 清理下 无效短信：DELETE FROM `pre_ucenter_pm_messages_1` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_2` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_3` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_4` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_5` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_6` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_7` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_8` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_9` WHERE `delstatus`='1' or `delstatus`='2';
DELETE FROM `pre_ucenter_pm_messages_0` WHERE `delstatus`='1' or `delstatus`='2';
页:
[1]