a week ago
Hi Team,
I am working on integration to push data to MYSQL , When we are using the Update on Duplicate condition i see the below error for some of the records
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', null, '', '', '', '', '1814208', '1814208','0','1','0001814208','') ON DUPLICA'
"INSERT INTO DummyTable (a,b,c,d,e,f,g,h,i,j,k,l) VALUES " + $valuesClause + " ON DUPLICATE KEY UPDATE " + $updateClause
This only happens for few records, If any one who faced this issue during the process of using MYSQL , Please Suggest if you have any solution.
Thanks,
Vamsi