Skip to content

Instantly share code, notes, and snippets.

@Hazem-Ben-Khalfallah

Hazem-Ben-Khalfallah/disable-foreign_key_constraint.sql

Last active June 14, 2019 16:19
Show Gist options
  • Save Hazem-Ben-Khalfallah/b0afb6e9b0361b48ef4738d810773753 to your computer and use it in GitHub Desktop.
Save Hazem-Ben-Khalfallah/b0afb6e9b0361b48ef4738d810773753 to your computer and use it in GitHub Desktop.
Download ZIP
[Disable a foreign key constraint in MySQL] #sql #mysql
Raw
disable-foreign_key_constraint.sql
#disable
SET FOREIGN_KEY_CHECKS=0;
#reenable
SET FOREIGN_KEY_CHECKS=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment