Reset auto increment value in mysql table

Question

My mysql table auto increment value are like 83321, right now this value is 4110234543.

How can reset my old auto increment value?

Thanks in Advance

PSR · Accepted Answer · 2013-05-23 10:27:45Z

5

You can reset the AUTO_INCREMENT by using the following

ALTER TABLE table_name AUTO_INCREMENT = 83321

answered May 23, 2013 at 10:27

40.4k43 gold badges115 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1