如何在Javascript中从mySQL循环数组

const mysql = require('mysql2');

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

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database: ', err);
    return;
  }
  console.log('Connected to MySQL database');
});

const sql = 'SELECT * FROM users';

connection.query(sql, (err, results) => {
  if (err) {
    console.error('Error executing MySQL query: ', err);
    return;
  }
  
  // 处理结果集
  results.forEach((row) => {
    console.log(row.id, row.name);
  });
});

connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL connection: ', err);
    return;
  }
  console.log('MySQL connection closed');
});