Starting the auto increment primary key at a certain value

[scrubbicus]

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?

[trq]

Why?

[MockY]

I was wondering the same. Also, why does it matter?

[QuickOldCar]

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.