How can I use async/await with MySQL in Node.js?

How can I use async/await with MySQL in Node.js?

You can use the mysql2 package, which supports promises. First, install it using npm.

What does the code look like?

Here's a simple example:

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

async function queryDatabase() {
    const connection = await mysql.createConnection({host: 'localhost', user: 'root', database: 'test'});
    const [rows, fields] = await connection.execute('SELECT * FROM users');
    console.log(rows);
}

queryDatabase();

What if I want to handle errors?

You can use try/catch blocks to handle errors gracefully:

async function queryDatabase() {
    try {
        const connection = await mysql.createConnection({host: 'localhost', user: 'root', database: 'test'});
        const [rows, fields] = await connection.execute('SELECT * FROM users');
        console.log(rows);
    } catch (error) {
        console.error('Error querying the database:', error);
    }
}