如何在node.js中用mysql制作异步函数

npm install mysql

const mysql = require('mysql');

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

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

async function executeQuery(query) {
  return new Promise((resolve, reject) => {
    connection.query(query, (error, results, fields) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
}

async function getUsers() {
  try {
    const query = 'SELECT * FROM users';
    const results = await executeQuery(query);
    console.log(results);
  } catch (error) {
    console.error('Error executing MySQL query: ' + error);
  }
}

getUsers();