Re: Create database with relationships using diagram

[Andy Deans]

hi chad,

thanks for help, one question i was wondering.

when i create a relationship in mysql workbench does that create the foreign key?

i see a few options in the diagram.

i.e.:

1 to 1 non identify
1 to many non identifying

is the one i am looking for to create the foreign key relationship the bottom one which says:

place a relationship using existing columns?

and in which order to you click for the relationship or does that not matter what one column you click first?

hope you can help.

many thanks