MySQL: View table-related foreign key relationships SQL _MySQL

Just take over MySQL data, often encounter a primary foreign key relationship, there is no E-R diagram to help, functions through SQL query: selectTABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAMEfromINFORMAT just took over MySQL data, often encounter a primary foreign key relationship, there is no E-R diagram to help, functions through SQL to query:

Select
TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME
From INFORMATION_SCHEMA.KEY_COLUMN_USAGE
Where
REFERENCED_TABLE_NAME ='

';