MySQL Forums
Forum List  »  Newbie

Table design?
Posted by: Denis Castel
Date: April 10, 2010 11:32PM

Hi, I'm new to mySQL. I can't wrap my head around how to do this:

I have one table with a list of peopleNames, itemUID and uniqueID

I have another table with a list of itemNames and uniqueID.

I have trouble with how one table item could be associated with multiple items from another table. I believe I'm missing a method?

Example: Peter has item 3, Bjorn has item 4, John has items 3 and 4. I also need to be able to do a quick search to know who has item 3.



Edited 1 time(s). Last edit at 04/10/2010 11:33PM by Denis Castel.

Options: ReplyQuote


Subject
Written By
Posted
Table design?
April 10, 2010 11:32PM
April 11, 2010 01:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.