MySQL Update Query with where clause in Nifi

[#1]

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.

[#2]

@rakesh chow

Use PutSQL processor instead of ExecuteSQL processor, PutSQL processor does inserts and updates to mysql.

You can have refer below links

https://community.hortonworks.com/articles/91849/design-nifi-flow-for-using-putsql-processor-to-per....

https://community.hortonworks.com/questions/54538/nifi-ingesting-a-file-from-sftp-and-insert-into-my...