从数组更新node.js mysql查询

const mysql = require('mysql');

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

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

// 定义要更新的数组数据
const dataArray = [
  { id: 1, name: 'John' },
  { id: 2, name: 'Jane' },
  { id: 3, name: 'Bob' }
];

// 循环遍历数组，执行更新查询
dataArray.forEach(data => {
  const { id, name } = data;
  const query = `UPDATE users SET name = '${name}' WHERE id = ${id}`;

  connection.query(query, (error, results, fields) => {
    if (error) throw error;
    console.log(`Updated user with id ${id}`);
  });
});

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