Re: Update Doesn't Update!

[<carsten]

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...

/ Carsten