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: 344

Filed under:
|
|
|
|

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

Related posts about mysql

Related posts about many-to-many