phpmyadmin This table does not contain a unique co

2019-09-22 03:29发布

This question is an exact duplicate of:

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.

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

I got this notification :

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

1条回答
手持菜刀,她持情操
2楼-- · 2019-09-22 04:24

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.

查看更多
登录 后发表回答