将多个输入数据从nodejs中的数组插入到MySQL

const mysql = require('mysql2');

const connection = mysql.createConnection({
  host: 'localhost',
  port: 3306,
  user: 'root',
  password: 'password',
  database: 'your_database',
});

const data = [
  { name: 'John', age: 25 },
  { name: 'Jane', age: 30 },
  { name: 'Alice', age: 28 },
];

data.forEach((item) => {
  const { name, age } = item;
  const query = 'INSERT INTO your_table (name, age) VALUES (?, ?)';
  
  connection.query(query, [name, age], (error, results) => {
    if (error) {
      console.error('Failed to insert data:', error);
    } else {
      console.log('Data inserted successfully:', results);
    }
  });
});