IITT网络服务中心

标题: 批量删除用户 [打印本页]

---

作者: admin    时间: 2018-6-25 17:59
标题: 批量删除用户
由于后台删除用户特别慢，而且遇到那些乱七八糟的机器人，一天几万个注册是小意思了
所以我们用SQL语句
！！！！！！！！！！！一定要要备份！！！！不备份与本站无关！！！！！！！必须备份才能执行以下语句！！！

1. set @delid = 10000 ;
   
2. delete from pre_home_feed where uid > @delid ;
   
3. delete from pre_home_share where uid > @delid ;
   
4. delete from pre_home_comment where uid > @delid ;
   
5. delete from pre_home_blogfield where uid > @delid ;
   
6. delete from pre_home_blog where uid > @delid ;
   
7. delete from pre_home_class where uid > @delid ;
   
8. delete from pre_home_pic where uid > @delid ;
   
9. delete from pre_common_member where uid > @delid ;
   
10. delete from pre_common_member_count where uid > @delid ;
    
11. delete from pre_common_member_field_forum where uid > @delid ;
    
12. delete from pre_common_member_field_home where uid > @delid ;
    
13. delete from pre_home_album where uid > @delid ;
    
14. delete from pre_home_docomment where uid > @delid ;
    
15. delete from pre_home_doing where uid > @delid ;
    
16. delete from pre_home_notification where uid > @delid ;
    
17. delete from pre_forum_post where uid > @delid ;
    
18. delete from pre_forum_thread where uid > @delid ;
    
19. delete from pre_portal_comment where uid > @delid ;
    
20. delete from pre_common_member_profile where uid > @delid ;
    
21. delete from pre_common_member_status where uid > @delid ;
    
22. delete from pre_ucenter_member where uid > @delid ;

复制代码

---

欢迎光临 IITT网络服务中心 (http://service.iitt.cc/)

Powered by Discuz! X3