Node.JS异步/等待MySQL获取插入行的结果

npm install mysql

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect();

const insertQuery = 'INSERT INTO mytable (column1, column2) VALUES (?, ?)';
const insertValues = ['value1', 'value2'];

connection.query(insertQuery, insertValues, (error, results) => {
  if (error) throw error;
  console.log('Inserted row:', results.insertId);
});

const util = require('util');
const query = util.promisify(connection.query).bind(connection);

async function insertRow() {
  try {
    const insertQuery = 'INSERT INTO mytable (column1, column2) VALUES (?, ?)';
    const insertValues = ['value1', 'value2'];

    const results = await query(insertQuery, insertValues);
    console.log('Inserted row:', results.insertId);
  } catch (error) {
    throw error;
  }
}

insertRow();