On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
<victorsubervi@stripped>
wrote:
> On Fri, Dec 11, 2009 at 5:13 AM, <carsten@stripped> wrote:
>
>>
>> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>> <victorsubervi@stripped>
>> wrote:
>>
>> > mysql> update products set sizes="('Small', 'Large')" where
>> SKU='prodSKU1';
>> > Query OK, 0 rows affected, 1 warning (0.00 sec)
>> > Rows matched: 1 Changed: 0 Warnings: 1
>> >
>> > mysql> show warnings;
>> > +---------+------+--------------------------------------------+
>> > | Level | Code | Message |
>> > +---------+------+--------------------------------------------+
>> > | Warning | 1265 | Data truncated for column 'sizes' at row 1 |
>> > +---------+------+--------------------------------------------+
>> > 1 row in set (0.00 sec)
>> >
>> >
>> > What do? How do I enter multiple values?
>>
>> Impossible to say, until you let us know how you defined the column in
>> the
>> first place...
>>
>
> Sorry. It's an enum of which the elements I am trying to add into a row
are
> elements of the same enum; that is, a subset.
You're using the wrong type. RTFM re. the difference between enums and
sets.
/ Carsten
