SQL代码：同步UCenter、Discuz 和 Uchome中的用户及与用户相关的日志或动态信息

IsaacZ

把在uc中有，而论坛用户表中没有的用户，给删除掉，可用以下代码升级数据库：

1. delete from uc_members where uid not in(select uid from cdb_members);
   
2. delete from uc_memberfields where uid not in(select uid from cdb_members);
   

复制代码

操作前请备份UC的数据库 uc_ 请自行替换为自己的表前缀 如果是FULL版本 就是cdb_uc_

以上来源：http://www.discuz.net/forum.php?mod=redirect&goto=findpost&ptid=1516259&pid=12750127



IsaacZ补注：同样地，可以使 Uchome 用户与论坛同步。代码如下：

删除无效Uchome 用户：

1. delete from uchome_member where uid not in(select uid from cdb_members);
   

复制代码

同时删除Uchome 空间：

1. delete from uchome_space where uid not in(select uid from cdb_members);
   

复制代码

同时删除Uchome 无效日志：

1. delete from uchome_blog where uid not in(select uid from cdb_members);
   
2. delete from uchome_blogfield where uid not in(select uid from cdb_members);
   

复制代码

删除论坛垃圾帖子传过来的动态（确保操作前已经在论坛和UC删除了相关用户）：

1. delete from uchome_feed where uid not in(select uid from cdb_members);
   

复制代码

这样那些垃圾就没有啦！


再重复贴一次上面的全部代码，下次好直接使用：

1. delete from uc_members where uid not in(select uid from cdb_members);
   
2. delete from uc_memberfields where uid not in(select uid from cdb_members);
   
3. delete from uchome_member where uid not in(select uid from cdb_members);
   
4. delete from uchome_space where uid not in(select uid from cdb_members);
   
5. delete from uchome_blog where uid not in(select uid from cdb_members);
   
6. delete from uchome_blogfield where uid not in(select uid from cdb_members);
   
7. delete from uchome_feed where uid not in(select uid from cdb_members);
   

复制代码