It might be faster to dump the table structure and re-create the table from the dump.
Or for MySQL 3.23 only,
TRUNCATE table_name
Is in 3.23 and the same thing as DELETE FROM table_name. See section 7.17 DELETE Syntax. The differences are:
•
Implemented as a drop and re-create of the table, which makes this much faster when deleting many rows.
•
Not transaction-safe; TRUNCATE will automaticly end the current transaction as if COMMIT would have been called.
•
Doesn't return the number of deleted rows.
•
As long as the table definition file `table_name.frm' is valid, the table can be re-created this way, even if the data or index files have become
corrupted.
