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.