Skip to content

Instantly share code, notes, and snippets.

@jachin

jachin/toggle_foreign_key_constraints.sql

Created September 1, 2011 21:45
Show Gist options
  • Save jachin/1187377 to your computer and use it in GitHub Desktop.
Save jachin/1187377 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL – Toggle Foreign Key Checks or Constraints
Raw
toggle_foreign_key_constraints.sql
-- Toggle off
SET foreign_key_checks = 0;
-- Toggle on
SET foreign_key_checks = 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment