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;