Changing user ID auto-increment number in MySQL?

  • Resolved Cristobal

    (@cristobal)


    19 years, 3 months ago

    Greetings!

    I have (and all of us have) a table called wp_users. There is a cell in this table called “ID”. It has an auto-increment option. Can you help me and tell how can I change the last number of this auto-increment option.

    For example, I have 14 real users. When I tested my site I created 5 test-users (just fakes). So the last user (fake-user) had an ID equal to 19. Then I deleted them. And now if somebody wants to register, he will get an ID equal to 20. But I want him to get an ID equal to 15.

    Where I can find the number which is used by auto-increment option in MySQL? Or how can I reset this number?

    Thanks!

    Vladimir

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Changing user ID auto-increment number in MySQL?’ is closed to new replies.