ufJZj2Je

1var mysql = require("mysql");
2var connection = mysql.createConnection({
3    host: 'localhost',
4    user: 'root',
5    password: 'admin',
6    database: 'manipal'
7});
8connection.connect();
9let createTable = `create table if not exists Books(
10    id int primary key auto_increment, 
11    title varchar(255)not null
12)`;
13connection.query(createTable,function(err, results, fields){
14    if(err){
15        console.log(err.message);
16    }
17});
18connection.end(function(err){
19    if(err){
20        return console.log(err.message);
21    }
22});
23console.log("Books Table created......");