Home >>Nodejs Tutorial >Node.js MySQL Delete Records

Node.js MySQL Delete Records

« Previous Next »

Node.js MySQL Delete Records

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

Delete record from table users where id is 1.

In example1 folder build a js file called "delete.js" and put the following data into it:

Example


var db = require('db');  
var con = db.createConnection({  
host: "localhost",  
user: "root",  
password: "",  
database: "phptpoint"  
});  
con.connect(function(err) {  
if (err) throw err;  
var sql = "DELETE FROM users WHERE id = '1'";  
con.query(sql, function (err, result) {  
if (err) throw err;  
console.log("Number of records deleted: " + result.affectedRows);  
});  
});

Now open terminal command and execute the following instruction:

Node delete.js

The deleted record can be verified using SELECT statement:

« Previous Next »

Nodejs Tutorial Nodejs - Environment Setup Node.js First Example Node.js REPL Node.js Package Manager(NPM) Node.js Command Line Options Node.js Global Objects Node.js OS Node.js Callbacks Concept Node.js Timer Node.js Errors Node.js Events Node.js - Event Emitter Node.js - Buffers Node.js - Streams Node.js - File System Node.js - Utility Modules Node.js - Web Module Node.js - Express Framework Node.js - RESTful API Node.js - Scaling Application Node.js - Packaging Node.js Query String Node.js Assertion Testing Node.Js Create Connection with MySQL Node.js MySQL Create Database Node.js MySQL Create Table Node.js MySQL Insert Records Node.js MySQL Update Records Node.js MySQL Select Records Node.js MySQL SELECT Unique Record Node.js MySQL Delete Records Node.js MySQL Drop Table Difference between Node.js and AngularJS Difference between Node.js and PHP Difference between Node.js and Python Difference between Node.js and Java

Node.js Interview Questions and Answers

No Sidebar ads