scrubbicus Posted March 22, 2011 Share Posted March 22, 2011 So my database has 9 entries in it, so it goes up to ID 9. Is there a way to make the next entry skip all the way to 101 without adding 92 more entries. If I added a new dummy entry and made the ID 100 would the next one automatically be 101 or would it be 10? Link to comment https://forums.phpfreaks.com/topic/231440-starting-the-auto-increment-primary-key-at-a-certain-value/ Share on other sites More sharing options...
trq Posted March 22, 2011 Share Posted March 22, 2011 Why? Link to comment https://forums.phpfreaks.com/topic/231440-starting-the-auto-increment-primary-key-at-a-certain-value/#findComment-1191068 Share on other sites More sharing options...
MockY Posted March 23, 2011 Share Posted March 23, 2011 I was wondering the same. Also, why does it matter? Link to comment https://forums.phpfreaks.com/topic/231440-starting-the-auto-increment-primary-key-at-a-certain-value/#findComment-1191097 Share on other sites More sharing options...
QuickOldCar Posted March 23, 2011 Share Posted March 23, 2011 If you added a new id of 100 the next auto increment would be 101. If you don't want those 9 you should delete them. If you want to set the auto increment values to a certain number do this: ALTER TABLE tbl_name AUTO_INCREMENT = xxx; tbl_name is your table name and xxx would be the new auto increment amount I personally see no reason to skip 100, if they are not to be used get rid of them, or set another field with publish/unpublish or similar. Link to comment https://forums.phpfreaks.com/topic/231440-starting-the-auto-increment-primary-key-at-a-certain-value/#findComment-1191163 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.