The TRUNCATE TABLE statement is used to remove all records from a table in MySQL. It performs the same function as a DELETE statement without a WHERE clause.

Warning: If you truncate a table, the TRUNCATE TABLE statement cannot be rolled back.

The syntax for the TRUNCATE TABLE statement in MySQL is

In that database name is optional but table name is reqired.

This example would truncate the table called employee and remove all records from that table.

Note:-

• When you truncate a table, the AUTO_INCREMENT counters on the table will be reset.
• MySQL truncates the table by dropping and creating the table. Thus, the DELETE triggers for the table do not fire during the truncation.
• you cannot truncate an InnoDB table that is referenced by a foreign key in another table.
• you cannot truncate a NDB table that is referenced by a foreign key in another table