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]
