How do I change the Auto Increment counter in MySQL?

by 
ALTER TABLE table_name 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.

https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html

Leave a Comment