SQL批量删除不活跃会员

1、按条件删除不活跃会员的空间

1. DELETE FROM uchome_space WHERE UNIX_TIMESTAMP()-lastlogin>86400*90

复制代码

这里是按照90天未登陆的条件；最好还加上其他条件，避免误删。比如

1. DELETE FROM uchome_space WHERE UNIX_TIMESTAMP()-lastlogin>86400*90 AND groupid = 5

复制代码

这里加上了用户组限制：普通用户。

1. DELETE FROM uchome_space WHERE UNIX_TIMESTAMP()-lastlogin>86400*90 AND groupid = 5 AND lastpost =0 AND avatar =0

复制代码

这里再加上了日志数为0，未上传头像的限制。

2、删除会员空间之后，再去清理好友数据，否则出现无法删除的“匿名”好友

1. DELETE FROM uchome_friend WHERE (uid NOT IN (SELECT uid FROM uchome_space) OR fuid NOT IN (SELECT uid FROM uchome_space))

复制代码

3、清理UCenter数据

1. DELETE FROM uc_members WHERE (uid NOT IN (SELECT uid FROM uchome_space))

复制代码

1. DELETE FROM uc_friends WHERE (uid NOT IN (SELECT uid FROM uchome_space) OR friendid NOT IN (SELECT uid FROM uchome_space))

复制代码

站个广告位！

LZ辛苦了, 好帖一定要顶

空间删除时，他的相册、日志、记录等一并删除了吗？

回复 4# 宁波人网
只是数据库里面删除记录
文件还在的
不过是无法正常访问到的

占个位置。。。