a month 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
2 weeks ago
Hi @Vamsik . I assume the error message is data related for the Update condition, and potential mismatch for some values. As a workaround, can you please try the below SL design where first you will use lookup snap to check the MySQL DB, if the record already exist there? And based on that to do the Insert or Update?