Cacher is the code snippet organizer for pro developers

If trying to truncate MySQL InnoDB tables and you are getting an error because of foreign keys constraints try disabling the foreign keys checks.

SET FOREIGN_KEY_CHECKS = 0;
..
TRUNCATE tableName;
TRUNCATE tableName2;
..
SET FOREIGN_KEY_CHECKS = 1;