My sql execute snap

[rjapala]

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

[rjapala]

Thank you @darshthakkar

[darshthakkar]

@rjapala - if you have your pipeline in Dev, you may want to try @alchemiz’s solution, I’m sure that will work 100%.

[rjapala]

@alchemiz @darshthakkar

One thing i faced with all the tries is it is showing common error “Batch operation failed” i still dont know why this error is throwing,
So i have used Pipeline execute snap and updating the record in child pipeline then it is working fine.

Iam thinking the problem is with Batch operation Previously i tried with single record it worked fine.

You guys know why this error throwing Or the Mysql execute snap does not support batch operation iam confused

[smudassir]

In your query, whatever string values you have pls quote them. If Set has string value then say Error_reason=‘$Error_reason’. And if where has string value then do WHERE Customer_ID=‘$Customer_ID’.

[rjapala]

Thank you for reply @smudassir

I tried with this scenario also but still it is throwing error