开发者

phpMyAdmin shows column value as drop-down when field type is int

I'm editing a table via phpMyAdmin and see that the dID column is allowing me to selec开发者_运维知识库t a value from a drop-down list. I initially set the column as an int.

phpMyAdmin shows column value as drop-down when field type is int

phpMyAdmin shows column value as drop-down when field type is int

Why is it doing this?


It is probably a foreign key (constraint), so the choices you have (values that are allowed) are limited to the values in the referenced table.


Just as a guess, perhaps the dropdown list contains values that are found in that column in pre-existing rows of your table. So if there are values that commonly appear, you can select them instead of having to type them in. But that's only a guess.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜