Async await mysql nodejs

const mysql = require('mysql'); // or use import if you use TS
const util = require('util');
const conn = mysql.createConnection({yourHOST/USER/PW/DB});

// node native promisify
const query = util.promisify(conn.query).bind(conn);

(async () => {
  try {
    const rows = await query('select count(*) as count from file_managed');
    console.log(rows);
  } finally {
    conn.end();
  }
})()

Source: stackoverflow.com

Similar codes

0 vote173 views2 answers
Database owner can't create new tables postgres
SQL
0 vote177 views1 answer
Sql server bool select
SQL
0 vote169 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
4 votes136 views2 answers
Select todays data postgres query
SQL
37 votes167 views3 answers
Duplicate records in sql
SQL
1 vote165 views1 answer
Input in mysql
SQL
0 vote185 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote171 views1 answer
Forcefully delete a row in mysql which has references
SQL
20 votes171 views3 answers
SQL query rename table
SQL
1 vote169 views1 answer
Import sql file mysql commadn line
SQL