What is MySQL TRUNCATE command used for?

As the name explains, it is used to remove all the record from the MySQL table.

Syntax

Truncate table table_name;

Example

mysql> Truncate table student;
Query OK, 0 rows affected (0.18 sec)

The query above deleted all the records from the ‘Student’ table. We can observe as MySQL returns empty set after running the following query −

mysql> select * from student;
Empty set (0.00 sec)

Samual Sam

Updated on 20-Jun-2020 06:00:13

• Related Questions & Answers
• What is MySQL DROP command used for?
• What is MySQL DELETE command used for?
• What is the difference between MySQL TRUNCATE and DELETE command?
• What is the significant difference between MySQL TRUNCATE and DROP command?
• What is the use of MySQL TRUNCATE() function?
• What is the significant difference between MySQL TRUNCATE() and ROUND() function?
• What is the command used to register gecko driver in Selenium?
• MySQL BIT_LENGTH() function is used for which purpose?
• For timestamp, which datatype is used in MySQL?
• MySQL command line client for Windows?
• What is an array and what is it used for?
• Truncate with condition in MySQL?
• MySQL truncate text with ellipsis?
• Which MySQL data type is used for long decimal?
• What is Get-Content in PowerShell used for?