TRUNCATE
TRUNCATE TABLE removes all rows from a table while retaining its definition. It is much more efficient than DELETE FROM table.
TRUNCATE TABLE monitor;
Query OK, 0 rows affected (0.02 sec)
TRUNCATE TABLE removes all rows from a table while retaining its definition. It is much more efficient than DELETE FROM table.
TRUNCATE TABLE monitor;
Query OK, 0 rows affected (0.02 sec)