>-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
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 t
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
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.catego
