How to reset AUTO INCREMENT in MySQL

Question

How can I reset the AUTO_INCREMENT of a field?
I want it to start counting from 1 again.

Answer 1

Hello @kartik,

You can reset the counter with:

ALTER TABLE tablename AUTO_INCREMENT = 1

Hope it helps!!
Thank you!