A. asc order var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; con.query("SELECT * FROM customers…
A. Fetch data with where() condition var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; con.query("SELECT…
A. Fetch data without condition var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; con.query("SELECT *…
var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); var sql = "INSERT INTO customers…
var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "", database: "nodejs" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); var sql = "CREATE TABLE members…
var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); con.query("CREATE DATABASE nodedb", function (err, result) { if…
npm install mysql var mysql = require('mysql'); var con = mysql.createConnection({ host: "localhost", user: "root", password: "" }); con.connect(function(err) { if (err) throw err; console.log("Connected!"); });