Skip to content

Instantly share code, notes, and snippets.

@afurculita

afurculita/gist:020650deef64e2602aba

Created October 22, 2014 13:30
Show Gist options
  • Save afurculita/020650deef64e2602aba to your computer and use it in GitHub Desktop.
Save afurculita/020650deef64e2602aba to your computer and use it in GitHub Desktop.
Download ZIP
MySQL – Disable Foreign Key Checks or Constraints
Raw
gistfile1.txt
SET foreign_key_checks =0;
DROP TABLE `table_name` ;
DELETE FROM `table_name` WHERE id = 1;
SET foreign_key_checks =1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment