Forum Discussion

Vamsik's avatar
Vamsik
New Contributor II
12 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; ...
  • ljupcho_machko1's avatar
    ljupcho_machko1
    12 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?

     

     

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