网站模板中心

您现在的位置:首页>>织梦大学>>安装使用

织梦清空所有会员的sql怎么写,织梦怎么清空会

来源: 编辑:admin 发布时间:2019-11-07热度:59 ℃
执行下面的sql语句即可完成清空,清空前建议先做好数据备份以免发生错误。 DELETE FROM dede_member WHERE mid = 2 and mid=200000; DELETE FROM dede_member_person WHERE mid = 2 and mid=200000; DELETE FROM dede_member...

执行下面的sql语句即可完成清空,清空前建议先做好数据备份以免发生错误。

DELETE FROM dede_member WHERE mid >= 2 and mid<=200000;

DELETE FROM dede_member_person WHERE mid >= 2 and mid<=200000;

DELETE FROM dede_member_space WHERE mid >= 2 and mid<=200000;

DELETE FROM dede_member_tj WHERE mid >= 2 and mid<=200000;

DELETE FROM dede_member_operation WHERE aid >= 2 and aid<=200000;

Pbootcms问题解决

请点击在线联系我们【点击咨询解决问题】   如果您有任何Pbootcms问题,我们将免费为您写解决教程!

    PB模板网:承接仿站业务,价格200元起!