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? Quote 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? Quote 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? Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.