[backcolor=rgb(255, 0, 0)]- 特别鸣谢：本教程由站长窝建站学习研究"*明"[/backcolor][backcolor=rgb(255, 0, 0)]友情分享，请勿二次转载、倒卖建站学习研究资源，一经发现，直接封号！-[/backcolor]
怎么将一个用户的uid更改，即uid：10001改成uid：10000：

UPDATE `pre_common_member` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_session` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_count` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_field_forum` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_field_home` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_profile` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_member_status` set uid=10000 WHERE uid=10001;
UPDATE `pre_common_statuser` set uid=10000 WHERE uid=10001;
UPDATE `pre_forum_post` set fid=10000 WHERE fid=10001;
UPDATE `pre_forum_post` set authorid=10000 WHERE authorid=10001;
UPDATE `pre_forum_thread` set fid=10000 WHERE fid=10001;
UPDATE `pre_forum_thread` set authorid=10000 WHERE authorid=10001;
UPDATE `pre_forum_groupuser` set uid=10000 WHERE uid=10001;
UPDATE `pre_forum_groupuser` set fid=10000 WHERE fid=10001;
UPDATE `pre_ucenter_friends` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_friends` set friendid=10000 WHERE friendid=10001;
UPDATE `pre_ucenter_memberfields` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_memberfields` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_members` set uid=10000 WHERE uid=10001;
UPDATE `pre_ucenter_pms` set msgfromid=10000 WHERE msgfromid=10001;
UPDATE `pre_ucenter_pms` set msgtoid=10000 WHERE msgtoid=10001;
UPDATE `pre_home_friend` set uid=10000 WHERE uid=10001;
UPDATE `pre_home_friend` set fuid=10000 WHERE fuid=10001;
UPDATE `pre_home_friendlog` set uid=10000 WHERE uid=10001;
UPDATE `pre_home_friendlog` set fuid=10000 WHERE fuid=10001;
UPDATE `pre_home_notification` set uid=10000 WHERE uid=10001;

这样就可以把uid10001的所有资料 包括贴子什么的 全部改成 uid10000的