批量删除用户
由于后台删除用户特别慢，而且遇到那些乱七八糟的机器人，一天几万个注册是小意思了所以我们用SQL语句
！！！！！！！！！！！一定要要备份！！！！不备份与本站无关！！！！！！！必须备份才能执行以下语句！！！set @delid = 10000 ;
delete from pre_home_feed where uid > @delid ;
delete from pre_home_share where uid > @delid ;
delete from pre_home_comment where uid > @delid ;
delete from pre_home_blogfield where uid > @delid ;
delete from pre_home_blog where uid > @delid ;
delete from pre_home_class where uid > @delid ;
delete from pre_home_pic where uid > @delid ;
delete from pre_common_member where uid > @delid ;
delete from pre_common_member_count where uid > @delid ;
delete from pre_common_member_field_forum where uid > @delid ;
delete from pre_common_member_field_home where uid > @delid ;
delete from pre_home_album where uid > @delid ;
delete from pre_home_docomment where uid > @delid ;
delete from pre_home_doing where uid > @delid ;
delete from pre_home_notification where uid > @delid ;
delete from pre_forum_post where uid > @delid ;
delete from pre_forum_thread where uid > @delid ;
delete from pre_portal_comment where uid > @delid ;
delete from pre_common_member_profile where uid > @delid ;
delete from pre_common_member_status where uid > @delid ;
delete from pre_ucenter_member where uid > @delid ;
页:
[1]