How to delete all rows in a MySQL or Oracle table
There are two methods:
DELETE FROM table_nameor
TRUNCATE TABLE table_nameThe latter is more efficient, because it does not reference each row before deleting; it is a bulk operation. The former is expanded into DELETE * FROM table_name, which works on one row at a time. Therefore, use the latter.