Cacher is the code snippet organizer for pro developers

UPDATE wp_users SET ID = 16 WHERE ID = 15;

UPDATE wp_usermeta SET user_id = 16 WHERE user_id = 15;

UPDATE wp_posts SET post_author = 16 WHERE post_author = 15;