truncate table

Sometimes you may need to delete all rows in a table in MySQL. Here’s how to truncate table in MySQL.