“内部关系”是什么意思?在 phpMyAdmin 中对 MyISAM 表做什么?
在 MyISAM 表的 phpMyAdmin v2.8.2.4 中,“关系视图”出现在“结构”选项卡下。它显示内部关系列表。但是,考虑到 MyISAM 不支持外键约束或关系完整性,它们会做什么呢?
从 phpMyAdmin 版本 3.2.0.1 开始,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?
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
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
MyISAM 中的外键仅供参考。您可以查看它们,看看引用完整性在哪里(如果有的话)。通过这种方式理解模式比通过查看作为副作用创建的索引来猜测关系更容易。
我不知道为什么它会在 phpMyAdmin 中消失,除非这是一个配置问题(我相信可以禁用该视图)?
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.
I don't know why it'd disappear in phpMyAdmin, unless it's a config issue (I believe the view can be disabled)?