On Fri, Dec 11, 2009 at 4:43 AM, <cars...@bitbybit.dk> wrote: > > On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi > <victorsube...@gmail.com> > 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