IITT网络服务中心

标题: SQL语句批量删除会员 [打印本页]

---

作者: admin    时间: 2018-6-28 23:14
标题: SQL语句批量删除会员
遇到大量机器人刷帖子，有几万几十万的时候，一个个删很麻烦。直接用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