标题: hu60wap6管理SQL:合并两个用户;删除用户
时间: 2020-02-06发布,2023-02-22修改
把 uid 23055 的所有数据都合并到 uid 22788:
update hu60_addin_chat_data   set        uid = 22788 where        uid = 23055;
update hu60_bbs_topic_content set        uid = 22788 where        uid = 23055;
update hu60_bbs_topic_meta    set        uid = 22788 where        uid = 23055;
update hu60_book_chapter      set        uid = 22788 where        uid = 23055;
update hu60_book_meta         set        uid = 22788 where        uid = 23055;
update hu60_friend_links      set        uid = 22788 where        uid = 23055;
update hu60_msg               set      touid = 22788 where      touid = 23055;
update hu60_msg               set      byuid = 22788 where      byuid = 23055;
update hu60_token             set        uid = 22788 where        uid = 23055;
update hu60_topic_favorites   set        uid = 22788 where        uid = 23055;
update hu60_user_relationship set origin_uid = 22788 where origin_uid = 23055;
update hu60_user_relationship set target_uid = 22788 where target_uid = 23055;
update hu60_userdata          set        uid = 22788 where        uid = 23055;
把 uid 23055 的用户信息合并到22788,用户名、密码用 23055 的:
delete from hu60_user         where      uid = 22788;
update hu60_user              set        uid = 22788 where        uid = 23055;
删除用户 uid 22788:
delete from hu60_addin_chat_data   where        uid = 22788;
delete from hu60_bbs_topic_content where        uid = 22788;
delete from hu60_bbs_topic_meta    where        uid = 22788;
delete from hu60_book_chapter      where        uid = 22788;
delete from hu60_book_meta         where        uid = 22788;
delete from hu60_friend_links      where        uid = 22788;
delete from hu60_msg               where      touid = 22788;
delete from hu60_msg               where      byuid = 22788;
delete from hu60_token             where        uid = 22788;
delete from hu60_topic_favorites   where        uid = 22788;
delete from hu60_user_relationship where origin_uid = 22788;
delete from hu60_user_relationship where target_uid = 22788;
delete from hu60_userdata          where        uid = 22788;
delete from hu60_user              where        uid = 22788;
『回复列表(7|隐藏机器人聊天)』