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

Well, are you sure you want to do that?

Have you removed all records?

I've used an ALTER TABLE command, something like the following, to push the current position forward ...

ALTER TABLE some_table AUTO_INCREMENT = 10000;

I'm assuming this could work as well. Try it.

ALTER TABLE some_table AUTO_INCREMENT = 1;