Solved

FK relationship in MySQL in WorkBench IDE

Posted on 2010-08-12
4
651 Views
Last Modified: 2013-11-08
i'm having trouble creating a one to many foreign key relationship between two InnoDB tables that I have created in my MySQL db using the workbench IDE. I'm using this in conjuction with vs 2010 and the entity framework. so i'm looking for some visual aids (tutorials preferably) that address this and show me the proper way to achieve this. Any suggestions and or suggested resources would be appreciated.
0
Comment
Question by:mikesExpertExchange
  • 2
  • 2
4 Comments
 
LVL 42

Accepted Solution

by:
dqmq earned 500 total points
ID: 33424308
You implement a one-many relationship simply by including a key of the parent table (the one) in the child table (the many).  Usually, it is the primary key, but any unique key will do.

If you want the database to enforce the integrity of that relationship, then you use a foreign key constraint.  The foreign key constraint is a "rule" applied to the child table that guarantees the value of the foreign key will be present in the referenced unique key of the parent table.

alter table CHILDTABLE add constraint CONSTRAINTNAME foreign key (COL1, COL2...) references PARENTTABLE (COL1, COL2)

I haven't used MySQL IDE, but most development enviornments provide a graphical way to create the necessary keys and constraints.  Someone else will need to assist you with that.  
0
 
LVL 1

Author Comment

by:mikesExpertExchange
ID: 33425010
thank you. as a sidenote, good, bad or indifferent, can you have a primary key that is a character string?
0
 
LVL 42

Expert Comment

by:dqmq
ID: 33432608
Absolutely!  But if it's longer than 16 bytes, I'd reconsider (for optimization reasons).
0
 
LVL 1

Author Comment

by:mikesExpertExchange
ID: 33432781
thanks for your help....
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now