MySQL: Is there a way to reset a table?

Question

Is there a way to reset a table?

I mean not only deleting all rows, but starting the auto_incrementing ID back to 0?

Answer 1

To remove all data:

TRUNCATE TABLE tablename

To reset the auto-increment:

ALTER TABLE tablename AUTO_INCREMENT = 1