Bug #1705 UPDATE can't update multiple fields
Submitted: 29 Oct 2003 15:17 Modified: 30 Nov 2003 8:54
Reporter: George Veskov Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.14-standard OS:FreeBSD (FreeBSD 4.6-RELEASE)
Assigned to: CPU Architecture:Any

[29 Oct 2003 15:17] George Veskov 
Description:
The UPDATE statement syntax for updating multiple fields actually doesn't work. So if you do something like

UPDATE foo SET field1=val1, field2=val2 WHERE field3=val3

the statement will succeed (i.e. not produce an error) but field1 and field2 will not be updated with the new val1 and val2 values. If you only update one value at a time this will work fine.

How to repeat:
Install MySQL 4.0.14-standard on FreeBSD 4.6 and then either with the command-line client or PHP/Perl DBI send an UPDATE statement which updates more than 1 field in a table. The update request will not succeed.

Suggested fix:
-
[30 Oct 2003 8:54] Indrek Siitan 
Can you provide us with a repeatable test case - table schema (CREATE
TABLE statements), minimal current records in the table, the exact
UPDATE syntax you're trying to run?

This is very basic SQL and should definitely work.
[14 Feb 2005 22:54] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".