Disable foreign key checks in MySQL
I frequently need to disable the foreign key constraint checks in MySQL when developing, but i often forget the command.
Here it is:
SET FOREIGN_KEY_CHECKS = 0;
Prepend this to the SQL query you are running to disable foreign key checks in the query that is about to be processed.