Change user ID number; _users, _usermeta, _posts and where else should I change?
-
Hi all,
I want to change ID numbers that assigned to each user, I’m using the following MySql command, but wonder if I should change any other table?
UPDATE wpprefix_users SET id = ‘9999’ WHERE id = ‘1’;
UPDATE wpprefix_usermeta SET user_id = ‘9999’ WHERE user_id = ‘1’;
UPDATE wpprefix_posts SET post_author = ‘9999’ WHERE post_author = ‘1’;
Thank you,
- The topic ‘Change user ID number; _users, _usermeta, _posts and where else should I change?’ is closed to new replies.