Skip to content

Instantly share code, notes, and snippets.

@6ui11em

6ui11em/diable_foreig_keys.sql

Created November 28, 2017 11:53
Show Gist options
  • Save 6ui11em/5fed9709ba4502153d039ad1bd4d7b75 to your computer and use it in GitHub Desktop.
Save 6ui11em/5fed9709ba4502153d039ad1bd4d7b75 to your computer and use it in GitHub Desktop.
Download ZIP
Disable / enable foreig keys #mysql
Raw
diable_foreig_keys.sql
SET foreign_key_checks = 0;
SET foreign_key_checks = 1;
# GLOBAL DISABLE
SET GLOBAL FOREIGN_KEY_CHECKS=0;
SET GLOBAL FOREIGN_KEY_CHECKS=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment