----- Original Message ----- From: "Andy Jackman" <[EMAIL PROTECTED]> To: "Mattias Larsson" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, August 02, 2003 4:23 PM Subject: Re: Adv. Mysql query
> Mattias, > It may not be such a good idea to store the 6 items in 1 record. An > alternative structure is one table with Item ID and Name and another > with Item Id and Component Id, both of which point back to item id in > the first table. I also thought that using the SET datatype would be good. But with a set you first of all are doing string instead of numeric matching. Second of all, I don't know if there is a way to take a set as a result set and pass each individual element of the set from a subquery. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
