Today i am working on my member pages. I want to add a username and password changing form. Suddenly, i realized that if a member is to be deleted, then what happens to the database row according to auto_increment? is the table automatically updated? I searched a bit and i see that the row is removed but nothing is changed in the auto_increment values. I see that one can use ALTER TABLE tablename AUTO_INCREMENT = x; to reuse that id but many people suggest to not reuse the id. I assumed that reset means that mysql will recount/move rows to fill in missing numbers. But this is not the case. So is okay to have missing numbers? it bothers me because it is unorganized but i can let it go if it is normal.
However, i also wonder how large should i make an id number to accomodate active members and deleted members? i currently have id int(11). I understand this to mean 11 digits (10,000,000,000) thus 10billion possibilities. Is this correct? I’m really nescient about this subject. I really do not know the answer.