userid değişmek

UPDATE `adminlog`  SET `userid`  =  '3' WHERE `adminlog`.`userid` =9;
UPDATE `announcement`  SET `userid`  =  '3' WHERE `announcement`.`userid` =9;
UPDATE `announcementread`  SET `userid`  =  '3' WHERE `announcementread`.`userid` =9;
UPDATE `attachment`  SET `userid`  =  '3' WHERE `attachment`.`userid` =9;
UPDATE `calendarmoderator`  SET `userid`  =  '3' WHERE `calendarmoderator`.`userid` =9;
UPDATE `cpsession`  SET `userid`  =  '3' WHERE `cpsession`.`userid` =9;
UPDATE `customavatar`  SET `userid`  =  '3' WHERE `customavatar`.`userid` =9;
UPDATE `customprofilepic`  SET `userid`  =  '3' WHERE `customprofilepic`.`userid` =9;
UPDATE `deletionlog`  SET `userid`  =  '3' WHERE `deletionlog`.`userid` =9;
UPDATE `editlog`  SET `userid`  =  '3' WHERE `editlog`.`userid` =9;
UPDATE `event`  SET `userid`  =  '3' WHERE `event`.`userid` =9;
UPDATE `forumread`  SET `userid`  =  '3' WHERE `forumread`.`userid` =9;
UPDATE `infraction`  SET `userid`  =  '3' WHERE `infraction`.`userid` =9;
UPDATE `moderator`  SET `userid`  =  '3' WHERE `moderator`.`userid` =9;
UPDATE `moderatorlog`  SET `userid`  =  '3' WHERE `moderatorlog`.`userid` =9;
UPDATE `passwordhistory`  SET `userid`  =  '3' WHERE `passwordhistory`.`userid` =9;
UPDATE `paymentinfo`  SET `userid`  =  '3' WHERE `paymentinfo`.`userid` =9;
UPDATE `pm`  SET `userid`  =  '3' WHERE `pm`.`userid` =9;
UPDATE `pmreceipt`  SET `userid`  =  '3' WHERE `pmreceipt`.`userid` =9;
UPDATE `pollvote`  SET `userid`  =  '3' WHERE `pollvote`.`userid` =9;
UPDATE `post`  SET `userid`  =  '3' WHERE `post`.`userid` =9;
UPDATE `posthash`  SET `userid`  =  '3' WHERE `posthash`.`userid` =9;
UPDATE `reminder`  SET `userid`  =  '3' WHERE `reminder`.`userid` =9;
UPDATE `reputation`  SET `userid`  =  '3' WHERE `reputation`.`userid` =9;
UPDATE `rssfeed`  SET `userid`  =  '3' WHERE `rssfeed`.`userid` =9;
UPDATE `search`  SET `userid`  =  '3' WHERE `search`.`userid` =9;
UPDATE `session`  SET `userid`  =  '3' WHERE `session`.`userid` =9;
UPDATE `sigparsed`  SET `userid`  =  '3' WHERE `sigparsed`.`userid` =9;
UPDATE `sigpic`  SET `userid`  =  '3' WHERE `sigpic`.`userid` =9;
UPDATE `subscribeevent`  SET `userid`  =  '3' WHERE `subscribeevent`.`userid` =9;
UPDATE `subscribeforum`  SET `userid`  =  '3' WHERE `subscribeforum`.`userid` =9;
UPDATE `subscribethread`  SET `userid`  =  '3' WHERE `subscribethread`.`userid` =9;
UPDATE `subscriptionlog`  SET `userid`  =  '3' WHERE `subscriptionlog`.`userid` =9;
UPDATE `tachyforumpost`  SET `userid`  =  '3' WHERE `tachyforumpost`.`userid` =9;
UPDATE `tachythreadpost`  SET `userid`  =  '3' WHERE `tachythreadpost`.`userid` =9;
UPDATE `threadrate`  SET `userid`  =  '3' WHERE `threadrate`.`userid` =9;
UPDATE `threadread`  SET `userid`  =  '3' WHERE `threadread`.`userid` =9;
UPDATE `user`  SET `userid`  =  '3' WHERE `user`.`userid` =9;
UPDATE `useractivation`  SET `userid`  =  '3' WHERE `useractivation`.`userid` =9;
UPDATE `userban`  SET `userid`  =  '3' WHERE `userban`.`userid` =9;
UPDATE `userfield`  SET `userid`  =  '3' WHERE `userfield`.`userid` =9;
UPDATE `usergroupleader`  SET `userid`  =  '3' WHERE `usergroupleader`.`userid` =9;
UPDATE `usergrouprequest`  SET `userid`  =  '3' WHERE `usergrouprequest`.`userid` =9;
UPDATE `usernote`  SET `userid`  =  '3' WHERE `usernote`.`userid` =9;
UPDATE `usertextfield`  SET `userid`  =  '3' WHERE `usertextfield`.`userid` =9;
UPDATE `thread` SET `postuserid` = '3' WHERE `thread`.`postuserid` =9;

UPDATE `access`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `administrator` SET `userid` = '1' WHERE `userid` =  '9';
UPDATE `adminlog`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `adminmessage` SET `statususerid` = '1' WHERE `statususerid` = '9';
UPDATE `album` SET `userid` = '1' WHERE `albumid` =9 LIMIT 1 ;
UPDATE `announcement`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `announcementread`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `attachment`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `calendarmoderator`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `cpsession`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `customavatar`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `customprofilepic`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `deletionlog`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `editlog`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `event`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `forumread`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `groupmessage`  SET `postuserid`  =  '1' WHERE `postuserid` = '9';
UPDATE `groupmessage_hash`  SET `postuserid`  =  '1' WHERE `postuserid` = '9';
UPDATE `infraction`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `moderator`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `moderatorlog`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `passwordhistory`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `paymentinfo`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `picture`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `pm`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `pmreceipt`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `pollvote`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `post`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `postedithistory`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `posthash`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `profilevisitor`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `reminder`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `reputation`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `rssfeed`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `search`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `session`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `sigparsed`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `sigpic`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `socialgroup`  SET `creatoruserid`  =  '1' WHERE `creatoruserid` = '9';
UPDATE `socialgroupmember`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `subscribeevent`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `subscribeforum`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `subscribethread`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `subscriptionlog`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `tachyforumcounter`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `tachyforumpost`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `tachythreadcounter`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `tachythreadpost`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `tagthread`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `thread` SET `postuserid` = '1' WHERE `postuserid` = '9';
UPDATE `threadrate`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `threadread`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `user`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `useractivation`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `userban`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `userchangelog`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `usercss`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `usercsscache`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `userfield`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `usergroupleader`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `usergrouprequest`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `userlist`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `usernote`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `usertextfield`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `visitormessage`  SET `userid`  =  '1' WHERE `userid` = '9';
UPDATE `visitormessage`  SET `postuserid`  =  '1' WHERE `postuserid` = '9';
UPDATE `visitormessage_hash`  SET `userid`  =  '1' WHERE `userid` = '9';