什么是“内部关系"?在phpMyAdmin中做MyISAM表? [英] What do "Internal Relations" do in phpMyAdmin for MyISAM tables?

问题描述

在MyISAM表的phpMyAdmin v2.8.2.4中，关系视图"出现在结构"选项卡下.它显示了内部关系列表.但是，鉴于MyISAM不支持外键约束或关系完整性，这些怎么办?

In phpMyAdmin v2.8.2.4 for MyISAM tables, the "Relation View" appears under the Structure tab. It shows a list of Internal Relations. But what do these do, given that MyISAM does not support foreign key constraints or relational integrity?

对于phpMyAdmin 3.2.0.1版，此页面(关系视图")不再出现​​在MyISAM表中.那么这是否意味着它根本没有做任何事情?

By phpMyAdmin version 3.2.0.1 this page ("Relation View") no longer appears for MyISAM tables. So does this mean that it wasn't doing anything in the first place?

任何解释都值得赞赏. 贾斯汀

Any explanations much appreciated. Justin

推荐答案

MyISAM中的外键仅用于咨询目的.您可以查看它们，以了解参照完整性 在哪里(如果有的话).以这种方式理解架构比通过查看作为副作用创建的索引来猜测关系要容易得多.

Foreign keys in MyISAM are for advisory purposes only. You can look at them to see where the referential integrity would be, if there were any. It's easier to understand the schema that way than to guess relations by looking at the indexes created as a side-effect.

我不知道为什么它会在phpMyAdmin中消失，除非是配置问题(我认为可以禁用该视图)?

I don't know why it'd disappear in phpMyAdmin, unless it's a config issue (I believe the view can be disabled)?

这篇关于什么是“内部关系"?在phpMyAdmin中做MyISAM表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！