Chris Olson Chris Olson - 2 months ago 6
MySQL Question

How do I change the Auto Increment counter in MySQL?

I have an ID field that is my primary key and is just an int field.

I have less than 300 rows but now every time someone signs up that ID auto inc is inputted really high like 11800089, 11800090, etc.... Is there a way to get that to come back down so it can follow the order (310,311,312).

Thanks!

Answer
ALTER TABLE tbl AUTO_INCREMENT=310;

Beware though, you don't want to repeat an ID. If the numbers are that high, they got that way somehow. Be very sure you don't have associated data with the lower ID numbers.

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