Skip to main content

TRUNCATE TABLE

Empties the table completely.

Syntax​

TRUNCATE TABLE [db.]name

Examples​

mysql> CREATE TABLE test(a UInt64, b Varchar) Engine = Memory;

mysql> INSERT INTO test(a,b) values(888, 'stars');

mysql> SELECT * FROM test;
+------+---------+
| a    | b       |
+------+---------+
|  888 |  stars  |
+------+---------+

mysql> TRUNCATE TABLE test;

mysql> SELECT * FROM test;