• 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.