Multiple occurences of field in table
I'm very new but I've used single flat tables and now I want to have a table that has some fields that contain multiple values. For example, a table of clothing items might have multiple colors and sizes for shirts, and a different set of colors and sizes for hats. How do I set up a table that allows multiple values for some of the fields in the table. I'm using MySQL Administrator 1.2.12 and MySQL Version 5.0.51. Is this a foreign key thing or something else. Sorry for the elementary question. All help appreciated.
Subject
Written By
Posted
Multiple occurences of field in table
November 18, 2009 08:09PM
November 18, 2009 10:15PM
November 19, 2009 07:13AM
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.