On Fri, Dec 11, 2009 at 5:33 AM, <cars...@bitbybit.dk> wrote: > > 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. >
k. Thanks, V