Like most people all my tables use a unique ID number to identify every record. I have this set to auto_increment.
My question is this:
Is there a way to set up the database so that it uses the lowest available ID number?
That is, say I put 100 records in one day, but they get used and deleted.
The next day, if I put another 100 records in they would use the IDs 101-200. Is there not a setting to just have it re-use 1-100 since those records no longer exist?