Many-to-Many Relationships in MySQL
Posted
by Kaji
on Stack Overflow
See other posts from Stack Overflow
or by Kaji
Published on 2010-04-13T20:27:31Z
Indexed on
2010/04/13
20:33 UTC
Read the original article
Hit count: 366
I've been reading up on foreign keys and joins recently, and have been pleasantly surprised that many of the basic concepts are things I'm already putting into practice. For example, with one project I'm currently working on, I'm organizing word lists, and have a table for the sets, like so:
`words` Table
`word_id`
`headword`
`category_id`
`categories` Table
`category_id`
`category_name`
Now, generally speaking this would be a one-to-many relationship, with several words being placed under a single category with the foreign key category_id
. Let's assume for a moment, however, that a user chooses to add another category to a word, making it many-to-many—Is there a way to set up my words
table to handle additional categories for words without creating extra columns like category_2
, category_3
, etc.?
© Stack Overflow or respective owner