Multiple foreign keys

Discussion in 'MySQL' started by Asmaa, Dec 9, 2011.

  1. Asmaa

    Asmaa New Member

    Joined:
    Dec 4, 2011
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Is a table can have more than one foreign keys references just one Primary key in another table?
    For example: (can it be and how?)
    Table 1: (have primary key: PK)
    Table2: (have foreign keys : FK1 , FK2, FK3)
    And all foreign key of table2 reference the primary key of table1.
    Thanks in advance
     
  2. tvrameshmc

    tvrameshmc New Member

    Joined:
    Jan 3, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Yes it is possible.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice