Skip to content

Instantly share code, notes, and snippets.

@imanabu

imanabu/IgnoreForeignKeyConstriants.sql

Last active August 9, 2019 22:22
Show Gist options
  • Save imanabu/041b275456c607ac2897 to your computer and use it in GitHub Desktop.
Save imanabu/041b275456c607ac2897 to your computer and use it in GitHub Desktop.
Download ZIP
mySQL Ignore Foreign Key Constraint Checks When Deleting
Raw
IgnoreForeignKeyConstriants.sql
use somedb;
SET FOREIGN_KEY_CHECKS=0;
delete from account where firstname='8';
select id, email, firstname, lastname from account;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment