phpmyadmin和外键 [英] phpmyadmin and foreign keys

问题描述

我为其中一个字段添加了一个外键约束。

插入时，该字段显示为下拉菜单而不是文本框。

但是下拉列表中的每个值都列出了两次，一次是减号前的值，一次是减号后的值。

像这样：

   -  value1 
  -  value2 
  -  value3 
 value1  -  
 value2  -  
 value3  -  
  

这是什么Phpmyadmin默认显示外键值和自定义描述字段旁边的（ ） 它是在表格的关系视图中设置的）。

FAQ_6.21rel =noreferrer> phpmyadminWiki 。

I added a foreign key constraint to one of my fields.

On insert, the field is showing up as a drop down instead of a text box, as expected.

But the drop down has each value listed twice, once with a minus sign before the value and once with the minus sign after the value.

Like this:

- value1
- value2
- value3
value1 -
value2 -
value3 -

What does this mean?

解决方案

Phpmyadmin by default shows foreign key value and a custom description field next to it (which is set in "Relation view" for the table) separated by hyphen.

See also phpmyadminWiki.

这篇关于phpmyadmin和外键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！