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.
/ Carsten
>
> mysql> select sizes, colorsShadesNumbersShort from products where ID=0;
> +-------+--------------------------+
> | sizes | colorsShadesNumbersShort |
> +-------+--------------------------+
> | | |
> +-------+--------------------------+
> 1 row in set (0.00 sec)
>
> Huh?
> TIA,
> Victor
>
>
> !DSPAM:451,4b221339930275276717544!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
