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

Database relationship

forums › forums › SQLyog › SQLyog Comments › Database relationship

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 11, 2004 at 1:57 pm #8363
      dahuan60
      Member

      I just create a new database in SQLYog. I need help to find a place to create their relationship.

      Thanks for any help!

    • March 12, 2004 at 5:38 pm #15563
      Ritesh
      Member

      First of all you need to create your table with InnoDB table handler. You can even change your existing table handlers to InnoDB by using

      Code:
      ALTER TABLE

      sql. For more information on InnoDB check out http://www.innodb.com.

      Then select the table in which you want to create the relationship and press F10. You can create or delete FKs with the resulting dialog. You can find a good tutorial on managing FK using SQLyog at http://www.weberdev.com/ViewArticle.php3?ArticleID=352

    • March 13, 2004 at 10:39 am #15564
      Shadow
      Member

      Just one little addition to Ritesh's post: check MySql's manual on InnoDB rather that InnoDB's own website!

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