MySQL Tip: How To Sterilize a MySQL database

Posted by & filed under MySQL.

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;