Disable Foreign Key checks or constraint in Mysql
Referential integrity/relation is one of the best feature for database architecuture. But in certain case we need to clear or disable these checks otherwise we can’t do normal modification within our data because if tow tables are following primary key and foreign key constraint then we must have to follow these relation otherwise we may get database errors.
The easiest way to disable foreign key is below command.
SET foreign_key_checks = 0;
DELETE FROM users where id > 45;
SET foreign_key_checks = 1;
By setting the foreign key check to 0, I was able to update / delete my users table. Once I was done with my operations on the user table, I reset the key check to 1 again and everything is back in place now.
Latest posts by Chandra Shekhar (see all)
- Best practices for micro service design - January 23, 2022
- Spring Boot - January 23, 2022
- Java - January 23, 2022