I have noticed that when you delete a record from mysql it does not assign the lowest next available number, for example if I have 20 records and they start from id10 and go up to id30 becuase I have already deleted records, how do I get mysql to set the next record to id1 again and use the available numbers?
