I have a mysql database and using phpmyadmin to add records to a table. I started off with and id (primary key) of 001 and the records were all in order up to 350. Then I added more records all at once and now my id's are scattered and not on order. Is there anyway to change the id's (all at once) so the record and record id's are in order with no skipped id's?
If you have any questions--let me know.
Thank you in advance for any help.