Change user ID and re-associate posts in WordPress

UPDATE `wp_posts`
SET `post_author` = 123456
WHERE `post_author` = 1;
UPDATE `wp_users`
SET `ID` = 123456
WHERE `ID` = 1;
UPDATE `wp_usermeta`
SET `user_id` = 123456
WHERE `user_id` = 1;