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

-1 vote224 views2 answers
How to display top 50 rows?
SQL
6 votes222 views2 answers
Return columns from table sql
SQL
10 votes227 views1 answer
All_dependencies
SQL
0 vote259 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote233 views1 answer
Sub query in linq
SQL
1 vote236 views1 answer
Sql eliminare un record
SQL
0 vote225 views1 answer
Mysql:5.6 syntax create table
SQL
0 vote224 views1 answer
Sqlserver now
SQL
1 vote243 views1 answer
Sql how to duplicate a table
SQL
0 vote240 views1 answer
Createdb with postgresql on ubuntu
SQL