How connect and select data from mysql.
These are following steps we need to connect the mysql database using node
1. Create a variable .
2. Create connection variable
3. Select data from table
This code is saved in mysqlselect.js file in your folder .
var mysql = require('mysql');
var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "demopass",
database: "mkjhadatabase"
});
con.connect(function(err) {
if (err) throw err;
con.query("SELECT * FROM users", function (err, result, fields) {
if (err) throw err;
console.log(result);
});
});
Test the result using node command
node mysqlselect.js
How connect and select data from mysql.
Reviewed by Mukesh Jha
on
5:27 AM
Rating:
![How connect and select data from mysql.](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh6kSwWvk8tPKCi2thW4co5oPo0-tLyI191OoI_aNK9QHV35nwAMcIoBMuYmlS7vV-VSE5n2yl9k6EnJ8h512nzS51zilGwu6G9AbT1n6wEjhnLzO3KKHHqGkQD9-XfsAXYWabJAX4dnLs/s72-w466-c-h259/Screenshot+2020-10-02+at+5.55.42+PM.png)
No comments:
Add your comment