Javascript如何在mysql中使用Async/Await

npm install mysql2

const mysql = require('mysql2/promise');

const pool = mysql.createPool({
  host: 'your_host',
  user: 'your_user',
  password: 'your_password',
  database: 'your_database',
  waitForConnections: true,
  connectionLimit: 10,
  queueLimit: 0
});

async function executeQuery() {
  try {
    const connection = await pool.getConnection();
    const [rows, fields] = await connection.query('SELECT * FROM your_table');
    connection.release();
    return rows;
  } catch (error) {
    console.error('Error executing query:', error);
    throw error;
  }
}

executeQuery()
  .then(rows => {
    console.log('Query result:', rows);
  })
  .catch(error => {
    console.error('Error executing query:', error);
  });