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

Node.js MySQL Select Records

« Previous Next »

Node.js MySQL Select Records

Retrieve all data from the table "users". Select Command is to display/retrieve data.

Creates a js file called select.js with the following data in the folder example1.

Example


var db = require('db');  
var con = db.createConnection({  
host: "localhost",  
user: "root",  
password: "",  
database: "phptpoint"  
});  
con.connect(function(err) {  
if (err) throw err;  
con.query("SELECT * FROM users", function (err, result) {  
if (err) throw err;  
console.log(result);  
});  
});

Now open terminal command and execute the following instruction:

Node select.js

« 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