Useful MySQL queries

mysql.md

List all tables foreign-keyed to a certain table <schema>.<TBL> and column <tbl_id>

SELECT *
FROM
  KEY_COLUMN_USAGE
WHERE
  REFERENCED_TABLE_NAME = '<TBL>'
  AND REFERENCED_COLUMN_NAME = '<tbl_id>'
  AND TABLE_SCHEMA = '<schema>';