1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.
  2. Better Analytics for WordPress Get It Free

PhpMyAdmin: How Do You Set Foreign Keys?

Discussion in 'MySQL' started by Masterful, Oct 2, 2008.

  1. #1
    How do you set foreign keys with PhpMyAdmin?

    I know the tables must be INNODB. And I read somewhere that the columns which will be used as foreign keys must be indexes. Is that true? If so, must these columns be made indexes on the child or parent table?

    Basically, I'm completely confused. If you know, please explain clearly, and I'll add some points to your account.
     
    Masterful, Oct 2, 2008 IP
  2. Masterful

    Masterful Active Member

    Messages:
    1,644
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    90
    #2
    Masterful, Oct 2, 2008 IP
  3. jestep

    jestep Prominent Member Premium Member

    Messages:
    3,540
    Likes Received:
    203
    Best Answers:
    18
    Trophy Points:
    330
    #3
    If you're looking for an easier way to manage a mysql DB try navicat. It makes managing a DB so much easier than phpmyadmin. You can see the exact foreign key relationships with every table as well as managing stored procedures, views, backups, and everything else.
     
    jestep, Oct 2, 2008 IP
    Masterful likes this.
  4. Masterful

    Masterful Active Member

    Messages:
    1,644
    Likes Received:
    27
    Best Answers:
    0
    Trophy Points:
    90
    #4
    Thanks for the advice. Sounds good . . . I might have to try it.
     
    Masterful, Oct 2, 2008 IP