在nodejs mysql async/await中运行多个查询

npm install mysql2

const mysql = require('mysql2');

const pool = mysql.createPool({
  host: 'your_host',
  user: 'your_user',
  password: 'your_password',
  database: 'your_database',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

const promisePool = pool.promise();

async function runMultipleQueries() {
  try {
    const [result1, fields1] = await promisePool.query('SELECT * FROM table1');
    console.log('Query 1 Result:', result1);

    const [result2, fields2] = await promisePool.query('SELECT * FROM table2');
    console.log('Query 2 Result:', result2);

    // 在这里可以继续添加更多的查询

    return [result1, result2]; // 返回查询结果
  } catch (error) {
    console.error('Error executing queries:', error);
    throw error;
  }
}

// 调用异步函数运行多个查询
runMultipleQueries()
  .then(results => {
    console.log('All queries executed successfully.');
    console.log('Results:', results);
  })
  .catch(error => {
    console.error('Error running queries:', error);
  });