Forum Discussion

rjapala's avatar
rjapala
New Contributor III
3 years ago

My sql execute snap

Am facing this error when am trying to update column data in SQL dynamically please can anyone give me a solution how to update with correct syntax using with expressions or without
darshthakkar's avatar
darshthakkar
Valued Contributor
3 years ago

This is really odd @rjapala.
Can you please try the following:

  1. Enable the error view on MySQL Execute and try running the pipeline again.
  2. Remove WHERE statement from your query however have a filter snap before My-SQL Execute so that it updates only 1 test record of your choice, please try with this and let us know your findings.