rooms = [];

var mysql = require('mysql');

var con = mysql.createConnection({
    host: "localhost",
    user: "MYUSERNAME",
    password: "MYPASSWORD",
    database: "travel"
});

con.connect(function(err) {
    if (err) throw err;
    con.query("SELECT * FROM rooms", function (err, result, fields) {
        if (err) throw err;
        var rooms = result;
        console.log(rooms[9]);
    });
});

console.log(rooms);