On Fri, 11 Dec 2009 05:28:41 -0500, Victor Subervi
<victorsube...@gmail.com>
wrote:
> On Fri, Dec 11, 2009 at 5:13 AM, <cars...@bitbybit.dk> wrote:
>
>>
>> On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi
>> <victorsube...@gmail.com>
>> 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
