Check for referential integrity

Question

In my process, I am doing something like:

SET FOREIGN_KEY_CHECKS = 0;
LOAD DATA INFILE '/path/to/mytable.txt' INTO TABLE mytable;
SET FOREIGN_KEY_CHECKS = 1;

Now I need to check that the data after this import does not violate referential integrity. I would like to do something like

check database all foreign_keys;

Is there a similar command? If not, how to do it?

Environment: MySQL v5.1.xx with InnoDB

thank

+3

Alban soupper Sep 16 '10 at 14:55

2 answers

, .

script, , FK, ( , FK , null, !):

+1

RedYeti 12 . '12 14:13

Stephanie Page · Accepted Answer · 2010-09-16T20:39:02+0000

Answer

Here is the code that does what you need. There seems to be no such team.

, MySQL, , . , , . "" .

~~, .~~

, , , , , .