TRUNCATE TABLE

Empties the table completely.

Syntax

TRUNCATE TABLE [db.]name

Examples

CREATE TABLE test(a BIGINT UNSIGNED, b VARCHAR) Engine = Memory;

INSERT INTO test(a,b) VALUES(888, 'stars');

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

TRUNCATE TABLE test;

SELECT * FROM test;