var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "account",
  password: "password",
  database: "test"
});

con.connect(function(err) {
  if (err) throw err;
  console.log("Connected!");

    con.query("SELECT id FROM `task` order by id desc limit 1", function (err, result) {
    if (err) throw err;
    console.log(result[0].id);
    var gid = result[0].id + 1;
    console.log(gid);

    var sql = "INSERT INTO `task` (`id`, `date`, `time`, `username`, `action`, `target`) VALUES ('"+gid+"', CURRENT_DATE(), CURRENT_TIME(), 'mum', 'hit', 'me')";
    con.query(sql, function (err, result) {
    if (err) throw err;
    console.log("1 record inserted");
    alert("1 record inserted"); //no alert shown
    });
    });
});