Re: Update Doesn't Update!

[Jørn Dahl-Stamnes]

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.

-- 
Jørn Dahl-Stamnes
homepage: http://www.dahl-stamnes.net/dahls/