var mysql = require("mysql");
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'admin',
    database: 'manipal'
});
connection.connect();
/*let createTable = `create table if not exists Books(
    id int primary key auto_increment,
    title varchar(255)not null
)`;
connection.query(createTable,function(err, results, fields){
    if(err){
        console.log(err.message);
    }
});
connection.end(function(err){
    if(err){
        return console.log(err.message);
    }
});
console.log("Books Table created......");*/
/*console.log("Connected......");
var sql = "INSERT INTO Books (title) VALUES('Learn Node JS')";
connection.query(sql,function(err,result){
    if(err) throw err;
    console.log("1 record inserted");
});*/
let sql = `DELETE from Books WHERE id = ?`;
//delete a row with id 1
connection.query(sql,1,(error,results,fields)=> {
    if(error)
    return console.error(error.message);
    console.log('Deleted Row(s):', results.affectedRows);
});
connection.end();