MySQL 如何使用 PHPMyAdmin 创建两个表之间的关系?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/2554903/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to create a relation between two tables using PHPMyAdmin?
提问by mouthpiec
How to create a relation between two tables using PHPMyAdmin?
如何使用 PHPMyAdmin 创建两个表之间的关系?
回答by Felix Kling
This only works if you use InnoDB
as storage engine. Then you have a link Relation view
besides Print view
:
这仅在您InnoDB
用作存储引擎时才有效。然后,你有一个链接Relation view
之外Print view
:
If you click this you get to another site where you can select the relations for all columns that have indecies defined on them (following the pattern table->column
).
如果单击此按钮,您将进入另一个站点,您可以在其中为所有定义了 indecies 的列选择关系(遵循模式table->column
)。