Javatpoint Logo
Javatpoint Logo

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:

Example:

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

Output:

mysql truncate table 1

See the table:

Output:

mysql truncate table 2
Next TopicMySQL DROP Table




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA