How can I set an AUTO_INCREMENT field to start with the value 6000 in MySQL?

user_432383 0
Viewed 42851

How can I set a non-auto-increment field to auto increment in MySQL? And how can I set the auto increment start value to 6000?

auto-increment mysql
3 Answers

mysql will show you the correct syntax for this, and more, if you execute the following for a table that contains an auto increment PK & some data already: 

SHOW CREATE TABLE your_tablename;
user_24089880
Related