Forum Discussion

Vamsik's avatar
Vamsik
New Contributor II
11 months ago
Solved

Issue with MYSQL Update on Duplicate condition

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

  • ljupcho_machko1's avatar
    ljupcho_machko1
    10 months 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?

     

     

1 Reply

  • ljupcho_machko1's avatar
    ljupcho_machko1
    New Contributor III
    10 months 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?