Node JS mysql删除具有数组数组的多行

const mysql = require('mysql');

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

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

// 定义要删除的数组条件
const idsToDelete = [1, 2, 3];

// 构建DELETE语句
const sql = `DELETE FROM mytable WHERE id IN (?)`;

// 执行DELETE语句
connection.query(sql, [idsToDelete], (error, results, fields) => {
  if (error) throw error;
  console.log(`Deleted ${results.affectedRows} rows`);
});

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