Node.js MySQL Select Unique Record

by Online Tutorials Library July 14, 2022

Node.js MySQL SELECT Unique Record

(WHERE Clause)

Retrieve a unique data from the table “employees”.

Create a js file named selectwhere.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 WHERE id = ‘1’”, function (err, result) {  if (err) throw err;  console.log(result);  });  });  

Now open command terminal and run the following command:

Node.js unique record 1

Node.js MySQL Select Wildcard

Retrieve a unique data by using wildcard from the table “employees”.

Create a js file named selectwildcard.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 WHERE city LIKE ‘A%'”, function (err, result) {  if (err) throw err;  console.log(result);  });  });  

Now open command terminal and run the following command:

It will retrieve the record where city start with A.

Node.js unique record 2

Next TopicNode.js MySQL Drop Table

Node.js MySQL Select Unique Record

Node.js MySQL SELECT Unique Record

(WHERE Clause)

Node.js MySQL Select Wildcard

Starting and Restarting Nginx

Change Password in Oracle

You may also like