I have a database where the ID auto_increment's. Well I just deleted a row out of the database and it is now incrementing as if the row was still there. Say it was row 22 that I deleted and I have now added new thing in, the ID looks like this: ... 19,20,21,23,24,25
See how it skipped putting anything in to 22? Also I added the 23,24,and 25th row elements in after I deleted the 22nd row. Does anyone know how to get MySQL to stop incrementing with that one number missing? It is messing up links on my site whenever something gets updated!
Thanks,
Adam Cavaliere