On Fri, 11 Dec 2009 10:48:59 +0100, Jørn Dahl-Stamnes <sq...@dahl-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. Then how did he manage to get a matched row? Of course you can have ID=0. / Carsten -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org