Q
Problem solve Get help with specific problems with your technologies, process and projects.

Nullifying foreign key statements when loading a test dev MySQL database

MySQL expert Mike Hillyer gives the shutoff command for foreign key checks when loading data.

Is there a way to write a SQL statement that will override (set to null) all foreign keys? I want to use this when loading a test development MySQL database.

When loading test data, you can issue the following statement to shut off foreign key checks in your session:

SET FOREIGN_KEY_CHECKS=0;

When you are finished loading your data, issue the following statement to turn foreign key checking back on:

SET FOREIGN_KEY_CHECKS=1;

Remember to have all foreign key requirements met before turning foreign key checks back on.

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

SearchServerVirtualization

SearchCloudComputing

Close