I'm trying to execute sql update query *update student set maxqueryid=0
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
Use PutSQL processor instead of ExecuteSQL processor, PutSQL processor does inserts and updates to mysql.
You can have refer below links