CODEWITHSUNDEEP
mysql
Abhishek Pandey
Abhishek Pandey

Reputation: 23

Reset auto increment value in mysql table

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

Upvotes: 0

Views: 280

Answers (1)

PSR
PSR

Reputation: 40348

You can reset the AUTO_INCREMENT by using the following 

ALTER TABLE table_name AUTO_INCREMENT = 83321

Upvotes: 5

Related Questions