Node.js MySQL Select Records

Node.js MySQL Select Records

Example

In this example, we’ll learn how to retrieve all data from a MySQL table named “employees” using Node.js.

First, create a file named select.js inside a folder called DBexample and add the following code:

Data Science Tutorial:–Click Here

var mysql = require('mysql');  
var con = mysql.createConnection({  
  host: "localhost",  
  user: "root",  
  password: "12345",  
  database: "updategadh"  
});  

con.connect(function(err) {  
  if (err) throw err;  
  con.query("SELECT * FROM employees", function (err, result) {  
    if (err) throw err;  
    console.log(result);  
  });  
});  

Running the Script

Once the file is ready, open your command terminal and navigate to the DBexample folder.
Run the following command to execute the script:

Introduction to Applied AI:–Click Here

node select.js

This command will connect to your MySQL database and fetch all records from the employees table. The retrieved data will be displayed directly in the terminal.

You can also test the SQL query separately in your MySQL environment:

Download New Real Time Projects :–Click here

SELECT * FROM employees;

This simple approach allows you to fetch and display data from a database using Node.js and MySQL with ease.

SQL Tutorial :–Click Here
Deep Learning Tutorial:– Click Here
Machine Learning Tutorial:–Click Here
Complete Advance AI topics:- CLICK HERE
Complete Python Course with Advance topics:-Click Here

node js mysql select records w3schools node js mysql select records stack overflow node js mysql select records example node js mysql query return result nodejs mysql query npm mysql nodejs mysql query with parameters connect mysql with node js express nodejs mysql select, mysql select query nodejs, node.js mysql select query example, node js mysql select data, nodejs express mysql, nodejs mysql order by, nodejs mysql connection pool, nodejs mysql crud, nodejs mysql tutorial, nodejs + mysql, nodejs mysql query, mysql and nodejs, connect nodejs with mysql database, execute mysql nodejs, how to connect mysql from nodejs, mysql order byquery nodejs, nodejs and mysql tutorials, mysql with nodejs, mysql example in nodejs, nodejs mysql pool query