MySQL Truncate Table

Truncate table in my sql

MySQL Truncate Table 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.


MySql Truncate Table 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;

Spread the love

Leave a Comment

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