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

Realtions And Foreign Keys

forums › forums › SQLyog › Using SQLyog › Realtions And Foreign Keys

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • January 17, 2006 at 11:07 am #9445
      talsnir
      Member

      Hello,

      I am rather new in SQLyog.

      I set it up, everything is working (almost…) – I can create new tables and insert new records.

      The thing is I can't relate, I changed all of my tables' engine to InnoDB, I can access the “Manage Relation' Dialog. Every time I am trying to make a link between tables (from an integer field of one table to a primary key of another table – the regular MS Access relation)) it gives me:

      “Error No. 1005. Can't create Table … (errono. 150)”

      and in addition it gives me a list of reasons which noone of them suites me.

      What's wrong? Do I need to define the linking field in the table in some special way? I tried to mark it as P/K and as Index but nothing helped…

      Please Help…

      Thank you so much…

      Tal

    • January 17, 2006 at 11:34 am #20275
      Ritesh
      Member

      A good discussion on the same can be found at: http://forums.mysql.com/read.php?22,19755,38307

    • January 17, 2006 at 11:41 am #20276
      Ritesh
      Member

      Make sure that the column definition for the source and target are same. InnoDB will not create FK even if there is a SIGN difference between the columns.

    • January 17, 2006 at 3:01 pm #20277
      peterlaursen
      Participant

      So … try making both integers UNSIGNED.

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