Product Solutions Support
Try MemSQL

TRUNCATE

Removes all rows from the table. TRUNCATE is equivalent to running a DELETE which removes all the rows from the table but without all the overhead of deleting one row at a time.

Syntax

TRUNCATE [TABLE] tbl_name

Remarks

Example

mysql> TRUNCATE TABLE mytbl;
Query OK, 1 row affected (6.32 sec)
Was this article useful?