Support Questions
Find answers, ask questions, and share your expertise

MySQL Update Query with where clause in Nifi

MySQL Update Query with where clause in Nifi

Hi Team,



I'm trying to execute sql update query *update student set maxqueryid=0
where id=1;*.
using ExecuteSQL Processor. It resulted with error saying data manuplation
cannot be done since it accepts only select statements. How do I achieve
this usecase is there any procesor to do this job. Any suggestion would be
appreciated.




Thnaks
Rakesh.

1 REPLY 1
Highlighted

Re: MySQL Update Query with where clause in Nifi

Super Guru