MySQL Forums
Forum List  »  Newbie

Re: best practices in relationship
Posted by: Peter Brawley
Date: January 27, 2013 09:58AM

To bridge tables a & b ...

table a(aid int pk)
table b(bid int pk)
table c(cid int pk, aid references a, bid references b)

Each row in c specifies exactly one pair of rows from a & b.

Options: ReplyQuote


Subject
Written By
Posted
Re: best practices in relationship
January 27, 2013 09:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.