MySQl change auto increment Starting number?

Question

Hi I have a dataset and I want to start and auto increment field at 5 not 1 is this possible?

cheers

JJ

Answer 1

You can use ALTER TABLE to change the auto_increment value:

ALTER TABLE tbl AUTO_INCREMENT = 5;

See the MySQL reference for more details.