M1850资源网 - 最专业的网站源码模板下载站!

全部作品
全部作品
织梦模板
网站模板
源码插件
游戏源码
脚本特效
视频教程
建站教程
M1850资源网 > 建站教程 > 织梦教程 > 织梦安装 > 织梦清空所有会员的sql怎么写,织梦怎么清空会员

推荐下载

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

执行下面的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;  
嘿,我来帮您!

展开