在mysql nodejs中插入对象数组

CREATE TABLE objects (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  age INT,
  email VARCHAR(255)
);

const mysql = require('mysql');

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

connection.connect();

const objects = [
  { name: 'John', age: 25, email: 'john@example.com' },
  { name: 'Jane', age: 30, email: 'jane@example.com' },
  { name: 'Bob', age: 35, email: 'bob@example.com' }
];

const query = 'INSERT INTO objects (name, age, email) VALUES ?';
const values = objects.map(obj => [obj.name, obj.age, obj.email]);

connection.query(query, [values], (error, results, fields) => {
  if (error) throw error;
  console.log('Objects inserted successfully');
});

connection.end();