Answer the question
In order to leave comments, you need to log in
How to view created MySQL links?
Good day! I can not find a command on the Internet to display already created links. Just because I did not manually indicate the name of the connection, I do not know what it is called. phpMyAdmin shows the name of this link, but I would like to know how to do it in the console.
Answer the question
In order to leave comments, you need to log in
The first result from Google is quite working:
SELECT
`TABLE_SCHEMA`
`TABLE_NAME`,
`COLUMN_NAME`,
`REFERENCED_TABLE_SCHEMA`,
`REFERENCED_TABLE_NAME`,
`REFERENCED_COLUMN_NAME`
FROM
`INFORMATION_SCHEMA`.`KEY_COLUMN_USAGE`
WHERE
`REFERENCED_TABLE_NAME` IS NOT NULL;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question