TA的每日心情 | 开心 4 天前 |
---|
签到天数: 26 天 [LV.4]偶尔看看III
|
- SELECT uid FROM `pre_ucenter_members` WHERE uid NOT IN (SELECT uid FROM `pre_common_member`);
[color=rgb(51, 102, 153) !important]复制代码
这个代码是查询,UC中没在DZ中的激活会员,一般查询出来UID后,自己进UC后台手工进行确认删除。这样最保险
另外,SQL命令有风险,执行所有的SQL的时候记得备份,因为这个是不可逆的。如果出现任何问题,本人不承认任何责任。
默认表头 bbs ,各位站长一定要改成 pre 或者你自己修改过的
- DELETE FROM `bbs_common_member_count` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
- DELETE FROM `bbs_common_member_field_forum` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
- DELETE FROM `bbs_common_member_field_home` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
- DELETE FROM `bbs_common_member_profile` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
- DELETE FROM `bbs_common_member_status` WHERE uid NOT IN(SELECT uid FROM `bbs_common_member`);
[color=rgb(51, 102, 153) !important]复制代码
以上代码是让DZ前台和后台显示的会员数目一致
|
|