Node.js MySQL Delete – How to delete data Using Node.js and MySQL

Node.js MySQL Delete: This tutorial will help you to delete the data of the MYSQL table row. it will be very useful for you. Even you will get the best & easy Node.js MySQL Delete Query with a Simple example. So, Read all the next steps and use the given concept in your project.

Node.js MySQL Delete Query with Example

before getting started,  You must create users table into the MySQL database and Insert into it. If you don’t know how to Insert Data form data. You can learn through the following URL

How to Insert Form Data into the table using Node.js & MySQL

1. Install Express Application

You have to Install Basic Express Application like the following project folder structure

myapp/
  |__bin
  |__node_modules
  |__public
  |__routes/
  |    |__index.js
  |    |__users.js
  |__views/
  |    |__index.ejs
  |    |__users.ejs
  |    |__user-list.ejs
  |__app.js
  |__database.js
  |__package-lock.json
  |__package.json

Note – If you have already installed the express application then you need not do it again

2. Connect Node.js App to MySQL

Create  database.js file and write the following Node.js MySQL connection Query.

File Name – database.js

var mysql = require('mysql');
var conn = mysql.createConnection({
  host: 'localhost', // Replace with your host name
  user: 'root',      // Replace with your database username
  password: '',      // Replace with your database password
  database: 'nodeapp' // // Replace with your database Name
}); 
conn.connect(function(err) {
  if (err) throw err;
  console.log('Database is connected successfully !');
});
module.exports = conn;

3. Create Delete Link Button

You have to create a delete button link for each record in the HTML table. So, to do it, you have to display all the records in an HTML table and just add the following line to delete data  –

<td><a href="/users/delete/<%=data.id%>">Delete</a></td>

You can learn to display data in HTML through the following URL

How to display Data from MySQL database table in Node.js

4. Create Routes to Delete Data

Configure the following points to create routes for deleting data –

• Include database connection file database.js
• Create a route /delete/:id with the GET method to display data in the HTML form

Path – routes/users.js

router.get('/delete/:id', function(req, res, next) {
  var id= req.params.id;
    var sql = 'DELETE FROM users WHERE id = ?';
    db.query(sql, [id], function (err, data) {
    if (err) throw err;
    console.log(data.affectedRows + " record(s) updated");
  });
  res.redirect('/users/user-list');
  
});

5. Load Route File into Root File

You must load the route file users.js into the root file app.js

var usersRouter = require('./routes/users');
app.use('/users',usersRouter);

Note – If the above code already exists in the app.js  then you can skip this step.

6. Run Node.js Code to update data 

To Run Node.js code for deleting data, you will have to do the following things –

• First of all, Start your Node.js server using npm start command
• Enter the following URL into your web browser to display records in an HTML table

http://localhost:3000/users/user-list

When you click the delete link button, data will be deleted successfully based on passing id from the delete link button.

My Suggestion

Dear developers, I hope you have understood the above script, Now you are able to delete data using Node.js & MySQL.Even you can delete another records by using the above steps.

If you have any questions or suggestions regarding Node.js. You can directly ask me through the below comment box.