mysql-delete-large-table.sql

#Method 1 (https://stackoverflow.com/questions/879327/quickest-way-to-delete-enormous-mysql-table)

CREATE TABLE new_foo LIKE foo;
RENAME TABLE foo TO old_foo, new_foo TO foo;
DROP TABLE old_foo;

#Method 2 (https://stackoverflow.com/questions/2300396/force-drop-mysql-bypassing-foreign-key-constraint)

SET foreign_key_checks = 0;
Truncate table foo;
SET foreign_key_checks = 1;