Results 1 to 5 of 5

Thread: Beginner: How do I create foreign keys using phpMyAdmin?

  1. #1
    Join Date
    Nov 2008
    Posts
    3

    Default Beginner: How do I create foreign keys using phpMyAdmin?

    I may be missing something obvious; how do I create foreign keys using phpMyAdmin?

    Thank you for reading. :)

  2. #2

    Default

    You can deploy foreign keys by making the table type InnoDB.

    DataMan

  3. #3

    Default

    Additionally, after the table type has been created at InnoDB, you define the foreign key relationship in PHPMyAdmin by clicking the relationship link in the structure view of the table.

    Sorry for the fragmented responses, it's been a tough night:).

    DataMan

  4. #4
    Join Date
    Nov 2008
    Posts
    3

    Default

    Thank you for taking the time to answer, dataman! :)

    If I may ask, would you recommend InnoDB for a forum? I've been reading about it and I can't quite figure out which would be best.

  5. #5

    Default

    Most forums come pre-packed with the data strucuture. If you're entertaining thoughts of doing your own forum from the ground up (not recommended), use of InnoDB should pose no problem. It's a standard data strucutre type that's been around for a long time.

    Good Luck,

    DataMan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •