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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-08-31 15:40:53  来源:igfitidea点击:

How to create a relation between two tables using PHPMyAdmin?

mysqlphpmyadmin

提问by mouthpiec

How to create a relation between two tables using PHPMyAdmin?

如何使用 PHPMyAdmin 创建两个表之间的关系?

回答by Felix Kling

This only works if you use InnoDBas storage engine. Then you have a link Relation viewbesides Print view:

这仅在您InnoDB用作存储引擎时才有效。然后,你有一个链接Relation view之外Print view

Relation 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)。

Link to

链接到