ucenter的用户总数与论坛显示的会员总数不一致的处理方法
发布时间:12/03 来源: 浏览:
关键词:
- insert into pre_common_member select * from pre_common_member_archive;
- insert into pre_common_member_count select * from pre_common_member_count_archive;
- insert into pre_common_member_field_forum select * from pre_common_member_field_forum_archive;
- insert into pre_common_member_field_home select * from pre_common_member_field_home_archive;
- insert into pre_common_member_profile select * from pre_common_member_profile_archive;
- insert into pre_common_member_status select * from pre_common_member_status_archive;
- TRUNCATE TABLE `pre_common_member_archive`;
- TRUNCATE TABLE `pre_common_member_count_archive`;
- TRUNCATE TABLE `pre_common_member_field_forum_archive`;
- TRUNCATE TABLE `pre_common_member_field_home_archive`;
- TRUNCATE TABLE `pre_common_member_profile_archive`;
- TRUNCATE TABLE `pre_common_member_status_archive`;