var
  sys = require('sys'),
  mysql = require('mysql-libmysqlclient'),
  conn,
  result,
  row,
  rows;
var
  host = "dbserver",
  user = "dbuser",
  password = "dbpassword",
  database = "dbdatabase",
  test_table = "dbtable";
conn = mysql.createConnectionSync();
conn.connectSync(host, user, password, database);
if (!conn.connectedSync()) {
  sys.puts("Connection error " + conn.connectErrno + ": " + conn.connectError);
  process.exit(1);
}
conn.query("SELECT * FROM " + test_table + " WHERE id=1;", function (err, res) {
  if (err) {
    throw err;
  }
  res.fetchAll(function (err, rows) {
    if (err) {
      throw err;
    }
    rows.forEach(function(registro) {
        var props = Object.keys(registro);
        props.forEach(function(campo) {
                sys.puts(campo + " :    " + registro[campo]);
        });
    });
  });
});