83
MariaDB TRUNCATE table Statement
In MariaDB database, TRUNCATE TABLE statement is used to delete all records from a table. It is same as DELETE statement without a WHERE clause.
Note: If you use the TRUNCATE table statement, the table will be deleted permanently and cannot be rolled back.
Syntax:
Example:
Let’s truncate the table “Students”.
The TRUNCATE query is executed successfully. You can see that the records of “Student” table have been deleted permanently.
Output:
There is no data in “Student” table.
Next TopicMariaDB Where