Skip to content

Instantly share code, notes, and snippets.

@Hazem-Ben-Khalfallah

Hazem-Ben-Khalfallah/disable_foreign_key_constraint.sql

Last active November 15, 2025 06:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Hazem-Ben-Khalfallah/b0afb6e9b0361b48ef4738d810773753 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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