OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Update Doesn't Update!

From: Victor Subervi (victorsubervigmail.com)
Date: Fri Dec 11 2009 - 04:05:46 CST

On Fri, Dec 11, 2009 at 4:48 AM, Jørn Dahl-Stamnes
<sql06dahl-stamnes.net>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.
>

Yikes! Then how do I update this table? I will need to update every variable
*except* the ID, which is the primary key and an auto_increment.
V