Re: Change AutoIncrement Value

[Jon Roshko]

I believe if you copy all the values (minus the auto_increment column) to another table then copy them back, all the auto_increment values will be re-generated. I haven't really tested this though.

If you just want to change the auto_increment value, use this:

ALTER TABLE tbl AUTO_INCREMENT = 100;

MySQL auto_increment page: http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html

- Jon