nodeslip6B

var mysql = require('mysql');

var con = mysql.createConnection({

  host: "localhost",

  user: "root",

  password: "",

  database: "Student_DB"

});

con.connect(function(err) {

  if (err) throw err;

  console.log("Connected!");

  

//                 //database create

//   con.query("CREATE DATABASE Student_DB", function (err, result) {

//     if (err) throw err;

//     console.log("Database created");

//   });

//              //table create

//  var table = "CREATE TABLE student (name VARCHAR(255), city VARCHAR(255))"

//    con.query(table, function (err, result) {

//     if (err) throw err;

//      console.log("Table created");

//    });

// //     //data insert

// var data1 = "INSERT INTO student (name, city) VALUES ('anuraj', 'Nasik')";

// var data2 = "INSERT INTO student (name, city) VALUES ('Prathmesh', 'Pune')";

// var data3 = "INSERT INTO student (name, city) VALUES ('Ramesh', 'Mumbai')";

// con.query(data1, function (err, result) {

//   if (err) throw err;

//   console.log( "no. 1 record inserted");

// });

// con.query(data2, function (err, result) {

//   if (err) throw err;

//   console.log( "no. 2 record inserted");

// });

// con.query(data3, function (err, result) {

//   if (err) throw err;

//   console.log( "no. 3 record inserted");

// });

con.query("SELECT city, name FROM student", function (err, result, fields) {

    if (err) throw err;

    console.log(result);

  });

});