karimali831 Posted August 27, 2010 Share Posted August 27, 2010 Hey, In my table, I have 773 rows like this: 10800 ... 772 ... 771 ... 770 ... 769 ... etc ... When I insert a new row, it will have an ID of 10801 and not 773. I delete row 10800 and I want to insert a new row that has an ID of 773. Is there a code I can use also so that it creates the IDs in order? 1, 2, 3 etc no missing numbers. Thanks. Quote Link to comment Share on other sites More sharing options...
samshel Posted August 27, 2010 Share Posted August 27, 2010 Not sure if this is what u r looking for: 0) Back up table so if anything goes wrong, u r not in soup 1) Delete the 10800 row. 2) use the following ALTER command to reset the auto increment: ALTER TABLE `table_name` AUTO_INCREMENT=773 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.