The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mysql database relations

Discussion in 'General Discussion' started by Golem, Jun 6, 2006.

  1. Golem

    Golem Registered

    Joined:
    Jun 6, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. webignition

    webignition Well-Known Member

    Joined:
    Jan 22, 2005
    Messages:
    1,880
    Likes Received:
    0
    Trophy Points:
    36
    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.
     
Loading...

Share This Page