Node.js MySQL Delete Record

by Online Tutorials Library July 14, 2022

Node.js MySQL Delete Records

The DELETE FROM command is used to delete records from the table.

Example

Delete employee from the table employees where city is Delhi.

Create a js file named “delete” in DBexample folder and put the following data into it:

  var mysql = require(‘mysql’);  var con = mysql.createConnection({  host: “localhost”,  user: “root”,  password: “12345”,  database: “tutoraspire”  });  con.connect(function(err) {  if (err) throw err;  var sql = “DELETE FROM employees WHERE city = ‘Delhi'”;  con.query(sql, function (err, result) {  if (err) throw err;  console.log(“Number of records deleted: ” + result.affectedRows);  });  });  

Now open command terminal and run the following command:

You can verify the deleted record by using SELECT statement:

Next TopicNode.js MySQL Select Record

Node.js MySQL Delete Record

Node.js MySQL Delete Records

Starting and Restarting Nginx

Change Password in Oracle

You may also like