Node.js MySQL Delete
Node.js Tutorial » Node.js MySQL Delete
Node.js Delete Query helps you to delete one or more rows from a table.
ORDER BY is used to sorts the records in ascending order by default. Sorting records in descending order, you have to use the DESC keyword.
Syntax:
Once installed this Node.js module can be used to manipulate the MySQL database:
MySQL Delete Records
Delete name from the table Users where name is Chris.
var conn = mysql.createConnection({
host: "localhost",
user: "your_username",
password: "your_password",
database: "my_db_name"
});
if (err) throw err;
var sql = "DELETE FROM Users WHERE name = 'Chris'";
conn.query(sql, function (err, result) {
if (err) throw err;
console.log("Record deleted: " + result.affectedRows);
});
});
Save the code above in a file named "demo_test_db_delete.js", and run the file:
After run the file will give you this result:
[
{ id: 3, name: 'Amy', address: 'Apple st 652'},
{ id: 2, name: 'Chris', address: 'Avenida 38'}, This row is DELETE
{ id: 6, name: 'Jack', address: 'Avenida 38'},
{ id: 4, name: 'Jony', address: 'Avenida 38'},
{ id: 1, name: 'Maria', address: 'Avenida 38'},
{ id: 5, name: 'Micha', address: 'Avenida 38'}
]
Related subjects:
node.js create database
nodejs create table
node.js MySQL select from
Order By
Tags: Node.js MySQL Delete multiple rows, example,
node js mysql delete multiple rows
node js delete file
node js delete request
MySQL DELETE Row Dynamic Query
MySQL DELETE Row Dynamic Query name column in table Users.
var mysql = require('mysql');
var conn = mysql.createConnection({
host: "localhost",
user: "your_username",
password: "your_password",
database: "my_db_name"
});
conn.connect(function(err) {
if (err) throw {
console.log("Database Connection Failed !!!", err);
return;
}
console.log("We are connected to my_db_name");
// notice the ? in below query
var sql = "DELETE FROM Users WHERE name = ?";
// Dynamic Value
let name = 'Chris';
// Notice the name variable below
// It will replace the ? in query
conn.query(query, name, (err, rows) => {
if(err) throw err;
console.log('Row deleted = ' + rows.affectedRows);
});
});
Save the code above in a file called "demo_test_db_delete2.js", and run the file:
After run the file will give you this result:
[
{ id: 5, name: 'Micha', address: 'Avenida 38'}
{ id: 1, name: 'Maria', address: 'Avenida 38'},
{ id: 4, name: 'Jony', address: 'Avenida 38'},
{ id: 6, name: 'Jack', address: 'Avenida 38'},
{ id: 2, name: 'Chris', address: 'Avenida 38'}, Row DELETED
{ id: 3, name: 'Amy', address: 'Apple st 652'},
]
Result Object
When execute query, the result object returned.
{
fieldCount: 0,
affectedRows: 1,
insertId: 0,
serverStatus: 34,
warningCount: 0,
message: '',
protocol41: true,
changedRows: 0
}
Node.js MySQL Delete multiple rows, example,
node js mysql delete multiple rows
node js delete file
node js delete request
Node.js MySQL Delete - nodejs
This tool makes it easy to create, adjust, and experiment with custom colors for the web.
Magnews2 is a modern and creative free magazine and news website template that will help you kick off your online project in style.
Find here examples of creative and unique website layouts.
Find here examples of creative and unique website CSS HTML menu.