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

possible duplicate of [mysql reset auto increment](http://stackoverflow.com/questions/8923114/mysql-reset-auto-increment) — Mahmoud Gamal, May 23 '13 at 10:27

score 5 · Answer 1 · answered May 23 '13 at 10:27

5

You can reset the AUTO_INCREMENT by using the following

ALTER TABLE table_name AUTO_INCREMENT = 83321

answered May 23 '13 at 10:27

PSR

1 Answers1