Bug #49257 UDATE query not working properly with AND operator instead of comma (,) separate
Submitted: 1 Dec 2009 12:37 Modified: 1 Dec 2009 12:55
Reporter: Dileep Kumar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.45 OS:Windows
Assigned to: CPU Architecture:Any
Tags: ) separated, UDATE query not working properly with AND operator instead of comma (

[1 Dec 2009 12:37] Dileep Kumar 
Description:
Hi,

While writing UPDATE query we will  like this :
Ex:-   UPDATE test_mysal SET Address = 'Bangalore' , FirstName = 'Dileep' WHERE Id = 1 ;

When we execute it will show :
Query OK, 1 row affected (0.00 sec) Rows matched: 1  Changed: 1  Warnings: 0.
It will update result in to the database.

With some alteration:
UPDATE test_mysal SET Address = 'Bangalore-68' AND FirstName = 'Dilip' WHERE Id = 1 ;

When we execute it will show :
Query OK, 1 row affected (0.00 sec) Rows matched: 1  Changed: 1  Warnings: 0.
it will not update database  and also it will not give error. It will says that it updated.

Regards
DileepKumar.C.C
power2dil@gmail.com

How to repeat:
U can write any update query using AND operator instead of comma (,) separated
[1 Dec 2009 12:53] MySQL Verification Team 
See bug: http://bugs.mysql.com/bug.php?id=26405.
[1 Dec 2009 12:55] MySQL Verification Team 
Thank you for the bug report. Duplicate of bug http://bugs.mysql.com/bug.php?id=26405.