Re: Update Doesn't Update!

[Martijn Tonies]

>> 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.

Are you serious??

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com