What do “Internal Relations” do in phpMyAdmin for

2019-06-20 05:27发布

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

1条回答
劳资没心,怎么记你
2楼-- · 2019-06-20 05:57

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)?

查看更多
登录 后发表回答