Update in MySQL DB table

Let’s see how we can Update in MySQL DB table using the DB connector in MuleSoft.

Create a project in Anypoint Studio

Add the HTTP listener and flow to get the request for an update

Drag and Drop Update activity in a flow

Create a MySQL connection by following the steps mentioned in Connect with MySQL DB through MuleSoft

Add the update statement and input parameter value

Set the response payload

Run the service

Test the endpoint in SOAP UI

We can see the record is updated in the table

Before

After

Sample Application – mysql-db-service

Sample SOAP UI project – MySQL-service-soapui-project