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

2022-01-05 00:00:00 mysql phpmyadmin

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

How to create a relation between two tables using PHPMyAdmin?

推荐答案

这仅在您使用 InnoDB 作为存储引擎时有效.然后你有一个链接 Relation view 除了 Print view:

This only works if you use InnoDB as storage engine. Then you have a link Relation view besides Print view:

如果您单击此按钮,您将进入另一个站点,您可以在其中为所有定义了非十进制的列选择关系(遵循模式 table->column).

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).

相关文章