Disable foreign key checks in MySQL

8/20/2021

Another short article in which I'm going to show you how to disable foreign key checks in mysql. Let's go!

Sometimes you want to just import a mysql dump or have to do something else in your database that conflicts with the foreign keys. For this reason there is the option of disabling foreign key checks when running a SQL script.

-- disable foreign key checks
SET FOREIGN_KEY_CHECKS=0; 

-- your sql code here

-- enable foreign key checks again
SET FOREIGN_KEY_CHECKS=1;

-- more sql code or nothing

And that's it! Now you can switch this option whenever you need it! 👍