如何使用node.js插入多个mysql查询？

npm install mysql

const mysql = require('mysql');

const pool = mysql.createPool({
  host: '数据库主机地址',
  user: '数据库用户名',
  password: '数据库密码',
  database: '数据库名',
});

const query1 = () => {
  return new Promise((resolve, reject) => {
    pool.query('SELECT * FROM table1', (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
};

const query2 = () => {
  return new Promise((resolve, reject) => {
    pool.query('SELECT * FROM table2', (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
};

const executeQueries = async () => {
  try {
    const result1 = await query1();
    const result2 = await query2();
    // 处理结果
  } catch (error) {
    // 处理错误
  }
};

executeQueries();

Promise.all([query1(), query2()])
  .then(([result1, result2]) => {
    // 处理结果
  })
  .catch(error => {
    // 处理错误
  });