Thread Starter
Anonymous
I already use phpmyadmin to modify manually my database,
but I wonder where the counters of database’s ids are stored, so that i can decrease it…
If WordPress is set to auto increment ids, it must keep trace of them somewhere…
S.O. can help me? Thanks!!!
I think you misunderstood charle97’s response. WordPress do not remember the user-id’s.
MySQL which is the database software providing the backend support has a feature of certain numeric fields that is called “auto_increment”. This means that the code does need not have to worry about looking up the previous value of the user_id and then incrementing it before saving entries the user table. Just creating a new user entry in the table auto increments the ID.
This is ALSO the same mechanism used for the Post ID, you will find that if you create a post and then delete it and create a new one, the new post will be one more than the deleted post. ID’s do not get re-used. In virtually all cases, these ID’s are internal to WordPress in how they are used and should have no consequences on the outward appearance and function of your Blog.
Having said all that, having deleted user #3 and created user #4, there is NO benefit in changing the new user’s ID back to #3. If anything that might cause issues.
So unless you have a real need to be changing the IDs that are automatically maintained, I would just let it be.
Regards
Thread Starter
Anonymous
Ah, sorry for misunderstanding. Now i understand what you mean.
Thanks for answering.
Regards
