TRUNCATE

The TRUNCATE TABLE table statement is used to delete all data from a table. It’s much more efficient than DELETE FROM table.

  1. TRUNCATE TABLE monitor;
  1. Query OK, 0 rows affected (0.02 sec)