first desc products
or try to
update products set sizes='Small' where
SKU='prodSKU1';
Best Regards!
Yang Wang
Tel.: 0769-21687397
Fax.: 0769-21685577
Email: yw...@lfm-agile.com.hk
----- Original Message -----
From: <cars...@bitbybit.dk>
To: "Victor Subervi" <victorsube...@gmail.com>
Cc: <mysql@lists.mysql.com>
Sent: Friday, December 11, 2009 6:13 PM
Subject: Re: Update Doesn't Update!
>
> 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...
>
> / Carsten
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=yw...@lfm-agile.com.hk
>
