当前位置 : 主页 > 建站教程 > dedecms >

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

来源:互联网 收集:自由互联 发布时间:2021-06-20
执行下面的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_membe
执行下面的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;
网友评论
相关栏目