V
V
Vladimir2016-09-08 12:12:27
MySQL
Vladimir, 2016-09-08 12:12:27

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

1 answer(s)
M
Maxim, 2016-09-08
@MasterGerold

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 question

Ask a Question

731 491 924 answers to any question