MySQL: Is there a way to reset tables?

Question

Is there a way to reset tables?

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

Answer 1

To delete all data:

TRUNCATE TABLE tablename 

In reset auto increment:

 ALTER TABLE tablename AUTO_INCREMENT = 1 

Answer 2

http://www.electrictoolbox.com/reset-auto-increment-value-mysql/