Async function main() { const mysql =

Question

Async function main() { const mysql =

require('mysql2/promise');
const connection = await mysql.createConnection({
host: '127.0.0.1',
port: 32768,
user: 'root',
password: 'root',
database: '000’
});

const [rows] = await connection.execute('SELECT * FROM category');

rows.forEach(async (row) => {
const [rows1] = await connection.execute('SELECT * FROM subcategory WHERE category_id = ?', [row.category_id]);
});

// close mysql connection
//await connection.close()
}

main();