MySQL TRUNCATE Table

MySQL TRUNCATE Table

MYSQL TRUNCATE statement removes the complete data without removing its structure.

The TRUNCATE TABLE statement is used when you want to delete the complete data from a table without removing the table structure.

Syntax:

mysql> TRUNCATE TABLE  table_name; 

Example:

This example specifies how to truncate a table. In this example, we truncate the table "cus_tbl".

mysql> TRUNCATE TABLE  cus_tbl;

Output:

truncate table

See the table:

mysql> SELECT* FROM cus_tbl;  

Output:

truncate table