MySQL Callback Module

db.js

var mysql = require('mysql');
var util = require('util');

//New comment for update
var pool = mysql.createPool({
  multipleStatements: true,
  host: 'localhost',
  user: 'root',
  database: 'test',
  password: 'password',
  dateStrings: 'date',
  connectionLimit: 20,
});

exports.execSQL = function(sql, callback){

  pool.getConnection(function(err,connection){

    if (err) throw err;


    connection.query(sql, function(err, rows, fields) {
      if (err) throw err;
        callback(rows);
    });

    connection.release();
  });
}

test.js

var db = require('./db');

var sql = "SELECT * from test";
//Query for VDT Number
db.execSQL(sql,function(data) {

console.log(data[0].idtest);

});