SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLENAME; SET FOREIGN_KEY_CHECKS = 1;
Truncating table safely ignoring foreign keys in MySQL
Reading Time: < 1 minute
SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLENAME; SET FOREIGN_KEY_CHECKS = 1;