How to truncate a table in MySQL database?

We can use TRUNCATE TABLE statement to delete records inside a table. TRUNCATE removes all the rows from a table without using any condition. It is a DML (Data Manipulation Language) command. We can not rollback after truncate and auto increment counter will rest with TRUNCATE.

Syntax:

TRUNCATE TABLE <table_name>;

Example:

TRUNCATE TABLE employees;