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

感谢您的支持,我会继续努力的!

打开微信/支付宝扫一扫,即可进行扫码打赏哦,分享从这里开始,精彩与您同在
点赞 (0)

小U源码 织梦学院 织梦清空所有会员的sql怎么写,织梦怎么清空会员 https://xuym.com/719758.html

常见问题

相关文章

官方客服团队

为您解决烦忧 - 24小时在线 专业服务