Unsupported Screen Size: The viewport size is too small for the theme to render properly.

foreign keys

forums › forums › SQLyog › Using SQLyog › foreign keys

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • December 3, 2003 at 10:19 pm #8263
      PPP
      Member

      hi

      I'm currently using SQLyog version 3.62 and having difficulties creating foreign key relationships between tables.

      whilst having all primary keys set-up

      how do I go about creating foreign keys?

    • December 4, 2003 at 2:13 am #15298
      Ritesh
      Member

      First of all change the table handlers to InnoDB table type. For more information about InnoDB table handlers visit http://www.innodb.com

      There is a very nice tutorial on setting up FK using SQLyog at http://www.weberdev.com/ViewArticle.php3?ArticleID=352. Check it out.

    • December 4, 2003 at 7:57 am #15299
      Shadow
      Member

      All participating columns must have indices, not just the referenced ones!

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.