problems with auto_increment


Please give me an idea to use the Number of a deleted row if the field is auto_increment.



I am curious why you need to re-use the numbers. This is ALWAYS a bad idea and there is really NEVER a reason for it. (“never say never? I’m saying never!”, thank you Chris Rock)


a way is given in this thread. Whether or not to use it is up to you. you can use a stack or text file or a database to hold the info.

Why do all that though when an int field holds a HUGE number?