Node预准备语句:在具有变量项的第二个查询中使用LAST_INSERT_ID

const mysql = require('mysql');

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

// 连接数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('Connected to the database');
});

// 第一个查询
const query1 = 'INSERT INTO users (name, email) VALUES (?, ?)';
const values1 = ['John Doe', 'john@example.com'];

connection.query(query1, values1, (err, result) => {
  if (err) throw err;
  console.log('User inserted with ID:', result.insertId);

  // 第二个查询
  const query2 = 'INSERT INTO orders (user_id, product) VALUES (?, ?)';
  const values2 = [result.insertId, 'Product A'];

  connection.query(query2, values2, (err, result) => {
    if (err) throw err;
    console.log('Order inserted with ID:', result.insertId);

    // 关闭数据库连接
    connection.end((err) => {
      if (err) throw err;
      console.log('Disconnected from the database');
    });
  });
});