node.jsとmysqlでselectをloopしてみる

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'pass',
  database: 'db_name'
});

connection.connect(function(err) 
{
  if (err) throw err;
    connection.query("SELECT * FROM tb_name", function (err, result, fields) 
    {
      if (err) throw err;
      var test = result;
      var length = Object.keys(result).length;
      console.log(   length   );

      for (var i = 0; i < length; i++) 
      {

      console.log(result[i].column_name);

      };

    });

});