Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Johan De Meersman (vegivamptuxera.be)
Date: Fri Dec 11 2009 - 06:43:52 CST
On Fri, Dec 11, 2009 at 11:19 AM, Mark Goodge <markgood-stuff.co.uk> wrote:
> Jørn Dahl-Stamnes wrote:
>> On Friday 11 December 2009 10:38, Victor Subervi wrote:
>>> 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.
> You can, but not if it's an auto-increment field.
Also, not *entirely* correct, although you have to jump through a few hoops:
it can occur if the field was changed to auto_increment *after* the 0 was
put in there.
Yes, I inherited a database like that once, and yes, it fucks up your day.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=vegivamptuxera.be