phpmyadmin该表不包含唯一列 [英] phpmyadmin This table does not contain a unique column

问题描述

我有一个桥接表，说它的表B包含2列，它们是表A和C的2列的FK.由于它们是其他PK列的引用，所以FK无法编辑是有道理的.

I've a bridge table, says it's table B which contains 2 columns and they are FK of 2 columns of table A and C. It make sense the FK can't be edit since they are references of other PK columns.

如果我在表B中有3列怎么办?看来整个表格都无法编辑.

What if I've 3 column in table B? It seem like the entire table can't be edit..

我收到此通知:

 This table does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

推荐答案

从FK出现表的原因是什么?这违反了规范化规则，因此您不应该真正将所有列都作为FK. FK用于标识该行中不应假定为FK的其他元素.

What is the reason your table would occur from FKs? That is against the normalization rules and you should not really have all of your columns as FKs. The FKs are used to identify the other elements of the row that are not suppose to be FKs.

这篇关于phpmyadmin该表不包含唯一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！