uncleflo
Registered since September 28th, 2017
Has a total of 4281 bookmarks.
Showing top Tags within 1 bookmarks
howto information development guide reference administration design website software solution online service product business uk tool company linux code server application system web list video marine create data experience tutorial description explanation learn technology build article blog world boat project download windows lookup security free performance javascript technical london beautiful control network tools support course file research purchase image library programming youtube example php install opensource construction community html quality computer feature profile power browser music platform process mobile work user share manage professional database hardware buy industry advice internet dance developer installation 3d camera search access customer travel material standard money test develop review documentation css photography engineering webdesign engine digital device speed event api source management program question client phone discussion simple content water story marketing yacht app account setup interface package idea fast communication compare cheap script market study easy live google resource operation contact demonstration startup
Tag selected: constraint.
Looking up constraint tag. Showing 1 results. Clear
Alexander Stetsenko » MySQL: how to ignore checking of foreign key constraints for InnoDB tables
Saved by uncleflo on February 16th, 2015.
There is a session variable FOREIGN_KEY_CHECKS which allows to ignore checking of foreign key constraints for InnoDB tables. If set to 1 (the default), foreign constraints are checked. If set to 0, they are ignored. Setting FOREIGN_KEY_CHECKS to 0 also affects data definition statements like DROP TABLE which drops tables that have foreign keys that are referred to by other tables. Disabling foreign key checking can be useful for reloading InnoDB tables in an order different from that required by their parent/child relationships.
mysql insert foreign ignore key constraint check sql dump import database solution problem drop flag
No further bookmarks found.