vygeneruje SQL pro kontrolu integrity celé databáze, pokud někdo vypnul cizí klíče a rozbil data

check_foreign_keys.sql

SELECT
  /*fk.CONSTRAINT_SCHEMA,
  fk.CONSTRAINT_NAME,
  fk.TABLE_NAME,
  col.COLUMN_NAME,
  fk.REFERENCED_TABLE_NAME,
  col.REFERENCED_COLUMN_NAME,*/
  CONCAT('SELECT * FROM `', fk.TABLE_NAME, '` WHERE `', col.COLUMN_NAME, '` NOT IN (SELECT `', col.REFERENCED_COLUMN_NAME, '` FROM `', fk.REFERENCED_TABLE_NAME, '`);') AS query
FROM `REFERENTIAL_CONSTRAINTS` fk
  JOIN KEY_COLUMN_USAGE col USING (CONSTRAINT_SCHEMA, CONSTRAINT_NAME)
WHERE fk.`CONSTRAINT_SCHEMA` = '{jméno databáze}'
ORDER BY fk.REFERENCED_TABLE_NAME;