mysql表之间的联系怎么看_mysql – 如何知道表之间的关系

以编程方式更好的方式是从INFORMATION_SCHEMA.KEY_COLUMN_USAGE表收集数据，如下所示：

SELECT

`TABLE_SCHEMA`, -- Foreign key schema

`TABLE_NAME`, -- Foreign key table

`COLUMN_NAME`, -- Foreign key column

`REFERENCED_TABLE_SCHEMA`, -- Origin key schema

`REFERENCED_TABLE_NAME`, -- Origin key table

`REFERENCED_COLUMN_NAME` -- Origin key column

FROM

`INFORMATION_SCHEMA`.`KEY_COLUMN_USAGE` -- Will fail if user don't have privilege

WHERE

`TABLE_SCHEMA` = SCHEMA() -- Detect current schema in USE

AND `REFERENCED_TABLE_NAME` IS NOT NULL; -- Only tables with foreign keys

另一个是

select * from INFORMATION_SCHEMA.TABLE_CONSTRAINTS;