MySQL with nodejs

mysql node er sathe use korar age amake mysql package install kore nite hoyeche

npm install mysql

eta deyar por ami use korte parsi nicher code tuk,, but aikhaneo kahini achilo,,, 

XAMPP server on thaka lagsilo. 

 var mysql = require('mysql');

var con = mysql.createConnection({

  host: "localhost",

  user: "root",

  password: "",

  database:'mydb'

});

con.connect(function(err) {

  if (err) throw err;

  console.log("Connected!");

//   var sql = "CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))";

    // var sql="CREATE TaBLE rifat2 (name VARCHAR(20), address VARCHAR(30))";

    const sql="Create table lala (id varchar(20), name varchar(32))";

  con.query(sql, function (err, result) {

    if (err) throw err;

    console.log("Table created");

  });

});