一个城市的信仰

discuz x3.4 数据库操作命令常用

discuz x3.4 数据库操作命令常用

Discuz!X3.4本地附件全部修改为远程附件的方法

update pre_forum_attachment_0 set remote=1 where remote=0;

update pre_forum_attachment_1 set remote=1 where remote=0;

update pre_forum_attachment_2 set remote=1 where remote=0;

update pre_forum_attachment_3 set remote=1 where remote=0;

update pre_forum_attachment_4 set remote=1 where remote=0;

update pre_forum_attachment_5 set remote=1 where remote=0;

update pre_forum_attachment_6 set remote=1 where remote=0;

update pre_forum_attachment_7 set remote=1 where remote=0;

update pre_forum_attachment_8 set remote=1 where remote=0;

update pre_forum_attachment_9 set remote=1 where remote=0;

批量替换论坛贴子内容:

update pre_forum_post SET message=REPLACE(message,’替换前’,’替换后’);

赞(1) 打赏
未经允许不得转载:东东 » discuz x3.4 数据库操作命令常用

评论 抢沙发

登录

找回密码

注册