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

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

Drag and Drop Insert activity in a flow

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