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