Sunday, 15 September 2013

MySQL interests table structure (how-to?)

MySQL interests table structure (how-to?)

I've been figuring my way around MySQL for a while now, reading tutorials
and such but I've got a good idea of how things work, so this time around
I'd like to see if I can do it myself but I'm a little confused on one
part.
I'm trying to create a interests table for users to interact between their
interests. I'm confused on how I'd go about storing the interests
information for the users.
user_interests table:
interest_id | interests_names |
How could I enter specific interests for them to use without them typing
their own into the database such as, sports, life, hobbies, food, music,
games, etc.
should I create another column in the user_interests for each user id to
be stored in there?
I'm lost on the table structure.

No comments:

Post a Comment