后台注水账号过多已经有2万个账号 请求如何批量删除

后台注水账号过多已经有2万个账号 请求如何批量删除

通过sql语句去phpmyadmin删除

DZ动力1009 发表于 2015-5-20 11:07
通过sql语句去phpmyadmin删除

可以提供sql语句吗

aabbcc8780 发表于 2015-5-20 11:09
可以提供sql语句吗

set @delid = 2000;
delete from pre_forum_post where authorid > @delid;
delete from pre_forum_thread where authorid > @delid;
delete from pre_common_member  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_ucenter_members where uid > @delid;
delete from pre_home_blog where uid > @delid;
delete from pre_home_blogfield where uid > @delid;
delete from pre_home_doing where uid > @delid;
delete from pre_home_feed where uid > @delid;
delete from pre_home_pic where uid > @delid;
delete from pre_home_share where uid > @delid;
delete from pre_ucenter_members where uid > @delid;

这个语句是uid大于2000以后的都删除