var mysql = require('mysql');

var connection = mysql.createConnection({
  host: '192.168.0.51',
  user: 'root',
  password: 'decisionM45#',
  database: 'ojsbcbs'
});

var connection2 = mysql.createConnection({
  host: '192.168.0.1',
  user: 'root',
  password: 'decisionM45#',
  database: 'ojsbcbs'
});

now=new Date();
today=now.getFullYear()+now.getMonth()+now.getDate()
const query="select count(*) from tr001 where tenant=(select tenant from ten01) and trdate="+today+";"

connection.query({sql:query,timeout:15000},
  function (err, rows, fields) {
    console.log("DATABASE 192.168.0.51");
    console.log(rows);
});

connection2.query({sql:query,timeout:15000},
  function (err, rows, fields) {
    console.log("DATABASE 192.168.0.1");
    console.log(rows);
});