Insert in MySQL DB table


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

Create a project in Anypoint Studio

Insert in MySQL DB table 


Add the HTTP listener and flow to get the request for insert

Insert in MySQL DB table 


Drag and Drop Insert activity in a flow

Insert in MySQL DB table 


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


Add the insert statement and input parameter value


Set the response payload


Run the service


Test the endpoint in SOAP UI


We can see the inserted record 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