Mysql database relations

[Golem]

Hi

I created database with few tables. How I can create relations between the tables? There's something about relation view at http://thedesignspace.net/MT2archives/000043.html#relation
but my phpmyadmin version doesn't have this. I use ISP server so there's nothing I could do I guess


-Golem

 

[webignition]

If you read the instructions carefully, you'll notice that you must modify the configuration for phpMyAdmin to allow relations.

However, MySQL currently offers no method for hard-coding relationships between tables. The relations feature in phpMyAdmin is only of relevance when using phpMyAdmin and does not create an actual relationship between tables.

As for modifying phpMyAdmin, you could contact your host and ask them to make the necessary changes. However as this would affect all users on the same server they may be unwilling to do so.

Another viable option would be for you to install your own copy of phpMyAdmin and do whatever you like with it.