I work with MySql, and I have a field auID, which has option auto_increment. This works ok, when I add new entries.
But when I delete an entry (say nr. 4), and then add a new one MySql starts counting from 5, instead of 4 again.
What do I have to do in order to let MySql count right?