List:General Discussion« Previous MessageNext Message »
From:<carsten Date:December 11 2009 9:43am
Subject:Re: Update Doesn't Update!
View as plain text  
On Fri, 11 Dec 2009 04:38:01 -0500, Victor Subervi
<victorsubervi@stripped>
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!
Thread
Update Doesn't Update!Victor Subervi11 Dec
  • Re: Update Doesn't Update!carsten11 Dec
    • Re: Update Doesn't Update!Victor Subervi11 Dec
      • Re: Update Doesn't Update!carsten11 Dec
        • Re: Update Doesn't Update!Victor Subervi11 Dec
          • Re: Update Doesn't Update!carsten11 Dec
            • Re: Update Doesn't Update!Victor Subervi11 Dec
  • Re: Update Doesn't Update!Jørn Dahl-Stamnes11 Dec
    • Re: Update Doesn't Update!Victor Subervi11 Dec
    • Re: Update Doesn't Update!Victor Subervi11 Dec
      • RE: Update Doesn't Update!misiaQ11 Dec
    • Re: Update Doesn't Update!carsten11 Dec
      • Re: Update Doesn't Update!Chris Knipe11 Dec
    • Re: Update Doesn't Update!Mark Goodge11 Dec
      • Re: Update Doesn't Update!Johan De Meersman11 Dec
        • Re: Update Doesn't Update!Victor Subervi11 Dec
          • Re: Update Doesn't Update!Johan De Meersman11 Dec
  • Re: Update Doesn't Update!Martijn Tonies11 Dec
  • Re: Update Doesn't Update!Yang Wang11 Dec