MySQL Tutorial

MySQL Truncate Table

In MySQL, the truncate statement removes the all data from database table, but it’s not removes the table’s structure.

You can use the truncate statement when you want to delete the complete data from the table without deleting table structure. See the below truncate statement syntax:

TRUNCATE TABLE  table_name;

1	TRUNCATE TABLE table_name;

Here is the example of MySQL truncate statement:

TRUNCATE TABLE  tbl_employee;

1	TRUNCATE TABLE tbl_employee;

MySQL TRUNCATE Table

The above MySQL query will delete the complete data from “tbl_employee” table. Now execute the below MySQL query to see the data from “tbl_employee” table:

select * from tbl_employee;

1	select * from tbl_employee;

mysql select data from table