Results 1 to 4 of 4

Thread: Foreign key

  1. #1
    Join Date
    Jan 2005
    Posts
    362

    Unanswered: Foreign key

    I have mysgl 3.23.47 max-debug and i can't create foreign keys, i use InnoDb, what is going wrong?
    Thank you
    Dimis

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    Do you have any error Message ?
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Jan 2005
    Posts
    362

    errono 150

    In mysql, dos the error code is 150, i read that maybe the syntax of sql is faulty but even if i make the syntax of www.mysql.com the error exist, also i tried with toad and sqlyog whith no success!
    dimis

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    The problem is that you do you have a problem with your index
    Both key and foreign key must be indexed.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

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