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. Link to comment https://forums.phpfreaks.com/topic/211905-auto-increment-id/ 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 Link to comment https://forums.phpfreaks.com/topic/211905-auto-increment-id/#findComment-1104477 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.