1. Home
  2. MySQL Tutorials
  3. MySQL TRUNCATE Table

MySQL TRUNCATE Table

MySQL TRUNCATE TABLE statement is a tool that is handy for tactfully eliminating data from a table. When you apply the TRUNCATE TABLE statement, the structure of a table in terms of its columns and rows will remain, while its data will be deleted.

Syntax:

TRUNCATE TABLE table_name;

Example:

In this example, we will truncate the table “employee”

mysql> TRUNCATE TABLE employee;

Mastery of MySQL involves the knowledge of both basic and advanced concepts. However, understanding the above concepts will pave the way for comprehending other related concepts.

Leave a Comment

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