28.10.2011, 18:13
If I remember correctly, that is impossible with AUTO_INCREMENT. Lets say you have ID 1, 2, 3, 4 and gang ID 2 gets deleted. You can not set the AUTO_INCREMENT to use 2 next time one is created and then continiue at 5.
I might be wrong of course!
You could assign the ID manually, that way you could store the ID that was deleted and then use it when someone creates a new one. It requires some thinking and coding but it is possible!
Good luck
I might be wrong of course!
You could assign the ID manually, that way you could store the ID that was deleted and then use it when someone creates a new one. It requires some thinking and coding but it is possible!
Good luck