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:
TRUNCATE TABLE table_name;
Example:
This example specifies how to truncate a table. In this example, we truncate the table "cus_tbl".
TRUNCATE TABLE cus_tbl;
Output:
See the table:
SELECT* FROM cus_tbl;
Output:
