Re: Update Doesn't Update!

[Victor Subervi]

On Fri, Dec 11, 2009 at 4:43 AM, <carsten@stripped> wrote:

>
> On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
> <victorsubervi@stripped>
> wrote:
> > Hi;
> >
> > mysql> update products set sizes="('Small', 'Large')" where ID=0;
> > Query OK, 0 rows affected, 1 warning (0.00 sec)
> > Rows matched: 1  Changed: 0  Warnings: 1
>
> "Warnings: 1"
>
> do a SHOW WARNINGS immediately after you execute the stmt.
>

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?
TIA,
V