Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables "events" and "categories" which
look like this
+-------------------+-------------------------+
| eventID | eventName |
+-------------------+-------------------------+
| 1 | Event A |
| 2 | Event B |
| 3 | Event C |
+-------------------+-------------------------+
Primary Key: eventID
+-------------------+-------------------------+
| categoryID | categoryName |
+-------------------+-------------------------+
| 1 | Category A |
| 2 | Category B |
| 3 | Category C |
+-------------------+-------------------------+
Primary Key: categoryID
The idea is that an event may have multiple categories and from what I've
read here (http://lists.mysql.com/mysql/171645), many-to-many relationships
in the database should be avoid. According to the link and a couple of
others I found, I'm supposed to create a separate "events_categories" table
and make linkages using a Foreign Key. Am not sure how to translate this to
a SQL query. Can I get some help.
Thanks a million!
Regards,
Suren