You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.


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.




  • This command must be run on the master aggregator node (see Node Requirements for MemSQL Commands).
  • If there is a long-running query executing at the time a TRUNCATE operation is run the TRUNCATE will block and wait for it to finish. This is the same locking that an ALTER operation does before running.


mysql> TRUNCATE TABLE mytbl;
Query OK, 1 row affected (6.32 sec)

Related Topics