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

Try this code:

ALTER TABLE Table_Name AUTO_INCREMENT=1

Want to learn SQL from basics! Here's the right video for you on SQL provided by Intellipaat: