Node.js MySQL Select Record

by Online Tutorials Library July 14, 2022

Node.js MySQL Select Records

Example

Retrieve all data from the table “employees”.

Create a js file named select.js having the following data in DBexample folder.

  var mysql = require(‘mysql’);  var con = mysql.createConnection({  host: “localhost”,  user: “root”,  password: “12345”,  database: “tutoraspire”  });  con.connect(function(err) {  if (err) throw err;  con.query(“SELECT * FROM employees”, function (err, result) {  if (err) throw err;  console.log(result);  });  });  

Now open command terminal and run the following command:

Node.js select record 1

You can also use the statement:

Node.js select record 2

Next TopicNode.js MySQL Select Unique record

Node.js MySQL Select Record

Node.js MySQL Select Records

Starting and Restarting Nginx

Change Password in Oracle

You may also like