NodeJS -获取新创建的id后更新MySQL字段

const mysql = require('mysql');

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

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to MySQL database:', err);
    return;
  }
  console.log('Connected to MySQL database');
});

const newUser = { name: 'John Doe', age: 25 };

connection.query('INSERT INTO users SET ?', newUser, (error, results, fields) => {
  if (error) {
    console.error('Error inserting new user:', error);
    return;
  }
  const newUserId = results.insertId;
  console.log('New user id:', newUserId);

  // 更新 MySQL 字段
  const updateQuery = 'UPDATE users SET someField = ? WHERE id = ?';
  const updateValues = ['some value', newUserId];

  connection.query(updateQuery, updateValues, (err, result) => {
    if (err) {
      console.error('Error updating MySQL field:', err);
      return;
    }
    console.log('MySQL field updated successfully');
  });
});

connection.end((err) => {
  if (err) {
    console.error('Error closing MySQL connection:', err);
    return;
  }
  console.log('MySQL connection closed');
});