MySQL在Node.js中未与Promise.All一起运行

const mysql = require('mysql');

// 创建数据库连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

// 连接数据库
connection.connect();

// 定义要执行的查询语句
const query1 = 'SELECT * FROM table1';
const query2 = 'SELECT * FROM table2';

// 使用Promise.all并行执行查询
Promise.all([
  new Promise((resolve, reject) => {
    connection.query(query1, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  }),
  new Promise((resolve, reject) => {
    connection.query(query2, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  })
])
  .then(([result1, result2]) => {
    // 处理查询结果
    console.log('Result 1:', result1);
    console.log('Result 2:', result2);
  })
  .catch(error => {
    // 处理错误
    console.error('Error:', error);
  })
  .finally(() => {
    // 关闭数据库连接
    connection.end();
  });