How to temporarly ignore foreign keys in MySQL InnoDB.
By Joao
SET FOREIGN_KEY_CHECKS = 0;
SELECT @@FOREIGN_KEY_CHECKS;
SET FOREIGN_KEY_CHECKS = 1;
Alexander Stetsenko blog has more info about it.
SET FOREIGN_KEY_CHECKS = 0;
SELECT @@FOREIGN_KEY_CHECKS;
SET FOREIGN_KEY_CHECKS = 1;
Alexander Stetsenko blog has more info about it.