foreign_key_checks

What Is Foreign_key_checks? Temporarily disabling referential constraints (set FOREIGN_KEY_CHECKS to 0) is useful when you need to re-create the tables and load data in any parent-child order. … As an alternative, you can firstly create tables without foreign key constraints, load data and then create foreign keys using ALTER TABLE statements. What is foreign key