SQL语句批量删除会员
遇到大量机器人刷帖子,有几万几十万的时候,一个个删很麻烦。直接用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]