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

Node.js MySQL Update Records

« Previous Next »

Node.js MySQL Update Records

The UPDATE command is used in table updating records.

Example

Update email in "users" table where id is 1.

Create a js file in DBexample folder named "update.js" and put the following data into it:


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 = "UPDATE users SET email = 'test@gmail.com' WHERE id = 1";  
con.query(sql, function (err, result) {  
if (err) throw err;  
console.log(result.affectedRows + " record(s) updated");  
});  
});

Now open terminal command and execute the following command:

Node update.js

It will update the email id.

« 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