Node.js MySQL Select From
MySQL package is used to get data from table in mysql using node js.
SELECT FROM mysql statement is used to fetch data from table in mysql database.
Example :
const mysql = require('mysql');
const db = mysql.createConnection({
host:"localhost",
user:"root",
password:"",
database :"electromart"
})
db.connect((err)=>{
if(err) {
console.log("Connection Error:"+err);
}else{
console.log("Connection is established successfully...");
db.query("select * from customer",(err,result)=>{
// console.log("Customer Data :"+JSON.stringify(result));
result.forEach(row => {
console.log("Full Name :"+row.fullname+" Email :" + row.email+" Phone : "+row.phone+ " Gender: "+row.gender);
});
});
}
})
Write above code in server.js file and run this program as below.
D:\nodejs\website> node server.js
It gives output as below.
Full Name :john Email :[email protected] Phone : 87777777 Gender: Male
Full Name :haresh Email :[email protected] Phone : 5656565656 Gender: Male
Full Name :jasmina Email :[email protected] Phone : 45454545 Gender: Female
Full Name :divya Email :[email protected] Phone : 6565656565 Gender: Female
Full Name :hansaraj Email :[email protected] Phone : 7876767677 Gender: Male
Comments