在节点js中的for循环内插入Mysql

const mysql = require('mysql');

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

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

// 定义要插入的数据
const data = [
  { name: 'John', age: 25 },
  { name: 'Jane', age: 30 },
  { name: 'Bob', age: 35 }
];

// 使用for循环插入数据
for (let i = 0; i < data.length; i++) {
  const sql = 'INSERT INTO users (name, age) VALUES (?, ?)';
  const values = [data[i].name, data[i].age];

  // 执行插入操作
  connection.query(sql, values, (error, results, fields) => {
    if (error) throw error;
    console.log('Data inserted successfully');
  });
}

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