How to reset AUTO_INCREMENT in Sql?

Forums SQLHow to reset AUTO_INCREMENT in Sql?
Staff asked 7 months ago

Answers (1)

Add Answer
monika gabani Marked As Accepted
Staff answered 7 months ago

You can reset the counter with:

ALTER TABLE tablename AUTO_INCREMENT = 1

 

Subscribe

Select Categories