MySQL Tip: How To Sterilize a MySQL database

To sterilize the any mysql database and reset auto increments to 0, without deleting the table you can:

Login to database: mysql -u dbusername -p

Delete all rows: DELETE FROM databasename; // (not specifying terms deletes all rows)

Reset Auto-inc: ALTER TABLE databasename AUTO_INCREMENT = 0;