Forum Discussion

Vamsik's avatar
Vamsik
New Contributor II
2 years 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
    2 years 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
2 years 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?