-Original Message-
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Sunday, February 22, 2009 2:39 PM
To: MySql
Subject: book categories
Here's a tough one...
In my library I have some 62 categories where a number of books can be
in several categories.
Now, to relate the categories table
Here's a tough one...
In my library I have some 62 categories where a number of books can be
in several categories.
Now, to relate the categories table(AS c) to the book table (AS a),
I assume that I need an intermediate table book_category (AS d)
linking d.bookID to the b.bookID and d.categoryID
Hi Phil,
relax you are on track!
First a little theory.
In this case you have the so called N-to-M relationship.
While if you need to relate one book to one author(given only one author per
book!)
you have the so called 1-to-N relationship, in this case you have the N-to-M
relationship.
If you are
Claudio Nanni wrote:
Hi Phil,
relax you are on track!
First a little theory.
In this case you have the so called N-to-M relationship.
While if you need to relate one book to one author(given only one author per
book!)
you have the so called 1-to-N relationship, in this case you have the