first desc products or try to
update products set sizes='Small' where SKU='prodSKU1'; Best Regards! Yang Wang Tel.: 0769-21687397 Fax.: 0769-21685577 Email: [email protected] ----- Original Message ----- From: <[email protected]> To: "Victor Subervi" <[email protected]> Cc: <[email protected]> Sent: Friday, December 11, 2009 6:13 PM Subject: Re: Update Doesn't Update! > > On Fri, 11 Dec 2009 05:09:52 -0500, Victor Subervi > <[email protected]> > 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 > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[email protected] >
