标题: 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|显示机器人聊天)』