In some cases, you want to delete all table data in a fast way and reset all auto increment columns. MySQL provides TRUNCATE table statement to allow you to do so. The SQL TRUNCATE statement is as follows:
TRUNCATE TABLE table_name
There are some points you should remember before using TRUNCATE TABLE statement:
- TRUNCATE TABLE statement drops table and recreates it therefore it is much faster than DELETE TABLE statement. However it is not transaction-safe.
- The number of deleted rows is not returned like SQL DELETE TABLE statement.
- ON DELETE triggers are not invoked because TRUNCATE does not use DELETE statement.
TRUNCATE TABLE emp_table;