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

Update in MySQL DB table 


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

Update in MySQL DB table 


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





Sample Application – mysql-db-service

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

Thank you for taking out time to read the above post. Hope you found it useful. In case of any questions, feel free to comment below. Also, if you are keen on knowing about a specific topic, happy to explore your recommendations as well.
For any latest updates or posts on our website, you can follow us on LinkedIn. Look forward to connecting with you there.

Share this:
Notify of
Inline Feedbacks
View all comments