You are on the right track.. but kill your relationships as you have them
currently defined... think of it this way... (one to many).. you have
movies and you have directors.. it should be one director to many movies
seeing that a movie normally only has one director.. so take you primary
key from directors and place that foreign key in the movies table. Remember:
one director has many movies, not one movie has many directors..
Make a field in your movies table exactly the same as the primary key in the
directors table, but don't autonumber it if that is what is in the primary
key of the directors table, just make it the same type( ie. Number, text,
date, etc). and make sure it has the exact same specs as the directors
primary key field except the autonumber type; and make sure the perimeter is
"allow duplicate key is set to yes, if you index the field in the movies
table), but you don't have to index the foreign key in the movie table if
the primary key of the directors table is already indexed. Just make the
foreign key, "allow duplicates 'YES' in the movie table..
Hope this helps..
From: Randy Hammons [mailto:rathlon1@stripped]
Sent: Sunday, October 20, 2002 8:43 AM
Subject: how do you define a relationship?
I think I've firmed my "theoritical" understanding of relationships enough
to be dangerous. Now for the logical part....how do you actually define a
relationship in mysql? For instance...
columns (movie id(pk) , movie title , year filmed)
columns (director id(pk), movie id(fk), total movies)
Here I have a primary key in each table which I have defined in my table
structure. I also have a foreign key in the directors table, but where did
I define that to the database? Is this a sort of relationship? Like a one
to many? I've noticed in some reading that certain keys are refered to by
their respective names ( column - whatever ) and the relatioship column is
defined as ( column - relwhatever ), is this the proper way to define a
relationship? Is the primary/foreignkey, relationship concept something
that is used by the database to replicate data or are they design tools used
to develope an independent, non repetitive data structure? Someone please
help...I'm so confused. Thanks so much....
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread122712@stripped>
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php