在nodejs中插入多个项的SQL查询

const mysql = require('mysql');

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

// 要插入的数据
const items = [
  ['value1', 'value2'],
  ['value3', 'value4']
];

// SQL插入语句模板
const sql = 'INSERT INTO table_name (column1, column2) VALUES (?, ?)';

// 执行插入操作
items.forEach(item => {
  connection.query(sql, item, (error, results, fields) => {
    if (error) throw error;
    console.log('插入成功');
  });
});

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