如何在nodejs中处理mysql select查询返回的数据

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.stack);
    return;
  }
  console.log('Connected to MySQL database as id ' + connection.threadId);
});

connection.query('SELECT * FROM mytable', (err, results) => {
  if (err) {
    console.error('Error executing MySQL query: ' + err.stack);
    return;
  }
  console.log('Query results:', results);
});

connection.query('SELECT * FROM mytable', (err, results) => {
  if (err) {
    console.error('Error executing MySQL query: ' + err.stack);
    return;
  }
  results.forEach((row) => {
    console.log('ID:', row.id);
    console.log('Name:', row.name);
    console.log('Age:', row.age);
  });
});

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