用mysql实现多个循环的Node.js查询

const mysql = require('mysql');

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

connection.connect();

// 定义一个异步函数来执行多个查询
async function runQueries() {
  try {
    // 第一个查询
    const [results1] = await new Promise((resolve, reject) => {
      connection.query('SELECT * FROM table1', (error, results) => {
        if (error) reject(error);
        else resolve(results);
      });
    });

    console.log('Results from table1:', results1);

    // 第二个查询
    const [results2] = await new Promise((resolve, reject) => {
      connection.query('SELECT * FROM table2 WHERE id IN (?)', [results1.map(row => row.id)], (error, results) => {
        if (error) reject(error);
        else resolve(results);
      });
    });

    console.log('Results from table2:', results2);

    // 更多查询...

  } catch (error) {
    console.error('Error executing queries:', error);
  } finally {
    // 关闭数据库连接
    connection.end();
  }
}

// 调用函数
runQueries();