When loading test data, you can issue the following statement to shut off foreign key checks in your session:
When you are finished loading your data, issue the following statement to turn foreign key checking back on:
Remember to have all foreign key requirements met before turning foreign key checks back on.
Dig deeper on Open source databases
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.