Results 1 to 2 of 2

Thread: mysql

  1. #1
    Join Date
    Sep 2013
    Posts
    1

    Unanswered: mysql

    can we have two foreign keys coming from the same table
    ex:

    .
    .
    foreign key (code) references menu(code),
    foreign key (item_name) references menu(item_name)

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    yes, you can have as many foreign keys as you need per table per whatever...
    you can only ever have one primary key per table
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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