自由者CG

标题: discuz清空短消息数据库 MYSQL 代码 [打印本页]

作者: Freeman    时间: 2020-9-13 18:10
标题: discuz清空短消息数据库 MYSQL 代码
论坛时间运营长了,给数据库瘦身,清空短消息是个不错的选择。
具体方法:
1、登录mysql
2、分别输入下面的语句
3、完成

DELETE FROM `pre_ucenter_pm_lists` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_members` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_0` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_1` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_2` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_3` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_4` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_5` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_6` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_7` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_8` WHERE 1 ;
DELETE FROM `pre_ucenter_pm_messages_9` WHERE 1 ;






欢迎光临 自由者CG (https://bbs.zhise168.com/) Powered by Discuz! X3.4