API for Delete Record using MySQL in Node.js

Before You start first go through this link for setting your Node.js API environment.

Here I will show you how to delete one record using MySQL in node.js server. Follow this below procedure.

Write Delete Query in Controller:

For deleting one record in MySQL table write query in “employeecontroller.js” file in “controller” folder.

MySQL query for deleting one record is :

delete from tbl_profile where id=1

Now use that query in the “employeecontroller.js” file in the “controller” folder.

Employeecontroller.js:

var db = require('../config/connection'); //reference of connection.js
var employees = {
Delete: function (id,callback) {
return db.query("delete from tbl_profile where id=?",[id], callback);
}
}
module.exports=employees;

Route Configuration for delete employee record:

For configuring route for deleting record in to employee profile table. Write route configuration code in “employeeroute.js” file in “route” folder.

Set DELETE method to delete employee profile details. Now use this following code in your “employeeroute.js” file in the “route” folder.

employeeroute.js:

var express = require('express');
var router = express.Router();
var employees = require('../controller/employeecontroller'); //Call your employee controller...
router.delete('/deleteById/:id', function (req, res, next) {
employees.Delete(req.params.id,function (err, rows) {
if (err) {
res.send(err);
}
else {
res.send(rows);
}
})
})
module.exports = router;
OUTPUT:

Now open postman for checking that node.js application. Write your URL and set the method type is DELETE and pass id through API URL in postman.




Click on the Send button then the output will be shown in the below window.



Check all the CRUD API following below link:

• Get All Records
• Get Record By Id
• Insert Record
• Update Record
• Delete Record