如何在带有异步和池的节点中使用Mysql2获取MySQL的insertId？

npm install mysql2

const mysql = require('mysql2');

const pool = mysql.createPool({
  host: '数据库主机地址',
  user: '数据库用户名',
  password: '数据库密码',
  database: '数据库名',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

pool.getConnection((err, connection) => {
  if (err) throw err;
  
  const sql = 'INSERT INTO 表名 (字段1, 字段2) VALUES (?, ?)';
  const values = ['值1', '值2'];
  
  connection.query(sql, values, (err, results) => {
    connection.release(); // 释放连接
    
    if (err) throw err;
    
    const insertId = results.insertId;
    console.log('插入成功，插入的ID为：', insertId);
  });
});

connection.release();