SQL  TRUNCATE  can be used to delete records in table .

Example

mysql> TRUNCATE TABLE orders;
Query OK, 0 rows affected (0.00 sec)