Temporarily disable a foreign key constraint in MySQL

SET FOREIGN_KEY_CHECKS=0;

make sure to



SET FOREIGN_KEY_CHECKS=1;

when finish.