Think that i have 3000 users... and think 100 new users registered.. if i remove 200 people from database.. there will remain 2900 users. but when new users registers their id's are automaticly given like 3101 3102 3103 etc...
his/her id will be over 3100 but there is only 2900 users on portal.. so it seems weird.. is it possible to fix this ? i mean if there is 2900 users on portal new registered user's id must be 2901.. not 3100...
is it possible to fix this?
spottedhog Captain
Joined: Apr 30, 2004
Posts: 566
Posted:
Fri Jun 16, 2006 2:51 am
It is not really possible to fix that, nor is there really any need to fix it.
What you are seeing is the auto-increment part of your MySQL database. MySQL will record the last unique ID used, and will give the next user the next higher number user ID when they register. The user ID is just a unique identifyer that can be easily programmed into various SQL queries for display and more in various ways.
The COUNT will be how many that are currently in the database. You will ALWAYS have a higher user ID number than the current COUNT of users.
Nothing weird about it...... just a database doing what it was programmed to do.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
