织梦清空所有会员的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;

 

从0基础开始学习织梦dedecms建站,分享全套的织梦dedecms网站搭建教程、织梦安装使用教程。 汇聚了最全、最新的织梦cms建站教程。包含dedecms建站、仿站教程;dedecms系统使用常见问题;主题插件推荐下载等!欢迎学习!

悟空源码资源不错。粉了

支持悟空源码，越来越好

支持悟空源码，越来越好

加油！悟空源码，继续努力！支持你！

谢谢楼主发布的资源下载，帮助我不少