Delete in MySQL DB table

 

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

Create a project in Anypoint Studio

 

Add the HTTP listener and flow to get request for delete

 

Drag and Drop Delete activity in a flow

 

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

 

Add the delete statement and input parameter

 

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 Deletion

 

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:
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments