TRUNCATE TABLE in MySQL

TRUNCATE TABLE
In MySQL, the TRUNCATE TABLE statement is used to truncate or remove records of a table but not the structure.

Syntax:

TRUNCATE TABLE table_name   

Example:

TRUNCATE TABLE items;

Output:

Query OK, 0 rows affected <0.07 sec>

Explanation:
The “items” is an already existing table which is truncated thus deleting all the data. Verify the result using the below query.
SELECT* FROM items;

Output:

Empty set <0.00 sec>
Please Share