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:

Here is the example of MySQL truncate statement:


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:

mysql select data from table

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.