List:General Discussion« Previous MessageNext Message »
From:<carsten Date:December 11 2009 10:12am
Subject:Re: Update Doesn't Update!
View as plain text  
On Fri, 11 Dec 2009 10:48:59 +0100, Jørn Dahl-Stamnes
<sql06@stripped> wrote:
> On Friday 11 December 2009 10:38, Victor Subervi 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
>   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Look at the message, 0 rows changed and 1 warning.
> You cannot have ID=0 if ID is an index.

Then how did he manage to get a matched row?

Of course you can have ID=0.

/ Carsten

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