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

2 votes223 views1 answer
SQL IF ELSE
SQL
0 vote190 views1 answer
Get only first row mysql
SQL
0 vote210 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
2 votes214 views2 answers
Checking data type in sql server
SQL
0 vote206 views1 answer
Mysql_num_fields in mysqli
SQL
1 vote206 views1 answer
How to check the mysql version mac
SQL
1 vote219 views1 answer
Psql autocomplete for mac brew install
SQL
0 vote261 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote217 views1 answer
Mysql order by where condition sub query
SQL
11 votes226 views1 answer
Oracle insert into where
SQL