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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
