执行下面的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;
感谢您阅读这篇织梦清空所有会员的sql怎么写，织梦怎么清空会员文章，希望可以帮助您解决使用织梦cms途中的问题，更多相关织梦cms教程关注我们万条网吧。
文章原文链接：https://www.wantiao.net/35697.html，转载请注明出处。免责声明：本站资源均来自互联网，仅供研究学习使用，禁止违法违规使用，产生法律纠纷本站概不负责！本站信息来源于网络，版权争议与本站无关。如有侵权请邮件与我们联系处理，敬请谅解！
请先 ！