nodeslip1b

 Create Database  create_db.js

Var mysql = require('mysql');

var con = mysql.createConnection({

  host: "localhost",

  user: "root",

  password: "",

});

con.connect(function(err) {

  if (err) throw err;

  console.log("Connected");

  var sql = "CREATE DATABASE  Student_DB";

  con.query(sql, function (err) {

    if (err) throw err;

    console.log("Database with name Student_DB created Successfully..");

  });

});

Creating Table Create_table.js

var con = mysql.createConnection({

  host: "localhost",

  user: "root",

  password: "",

  database: "Student_DB"

});

con.connect(function(err) {

  if (err) throw err;

  console.log("Connected");

  var sql = "CREATE TABLE Student(Rno INT(5),Sname VARCHAR(100), Per INT(3))";

  con.query(sql, function (err) {

    if (err) throw err;

    console.log("Table created");

  });

});