Bug #74013 Throw an error in query parsing
Submitted: 22 Sep 2014 13:51
Reporter: Steel Brain Email Updates:
Status: Open Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[22 Sep 2014 13:51] Steel Brain
Currently if you execute a query that updates multiple rows and using `and` instead of commas to separate the parameters, it doesn't throw an error. and the developers often spends hours of time in bug hunting

How to repeat:
Update test.table set key_1 = 2 and key_2 =3 where id = 1;

Suggested fix:
Update test.table set key_1 = 2, key_2 = 3 where id = 1;