如何以数组形式运行多个查询

// 定义包含多个查询的数组
const queries = [
  "SELECT * FROM table1",
  "SELECT * FROM table2",
  "SELECT * FROM table3"
];

// 使用循环结构执行每个查询
queries.forEach(query => {
  // 执行查询的代码
  console.log("Running query:", query);
  // 这里可以调用相应的后端接口或者数据库操作来执行查询
});

const mysql = require('mysql');

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

// 定义包含多个查询的数组
const queries = [
  "SELECT * FROM table1",
  "SELECT * FROM table2",
  "SELECT * FROM table3"
];

// 使用循环结构执行每个查询
queries.forEach(query => {
  // 执行查询
  connection.query(query, (error, results) => {
    if (error) throw error;
    // 处理查询结果
    console.log("Query result:", results);
  });
});

// 关闭数据库连接
connection.end();