How to reset AUTO_INCREMENT in Sql?

Forums SQLHow to reset AUTO_INCREMENT in Sql?
Staff asked 3 years ago

Answers (1)

Add Answer
monika gabani Marked As Accepted
Staff answered 3 years ago

You can reset the counter with:

ALTER TABLE tablename AUTO_INCREMENT = 1

 

Subscribe

Select Categories