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

5 votes358 views2 answers
Sql conn
SQL
1 vote320 views2 answers
T-sql random number for each row
SQL
1 vote357 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote352 views1 answer
Grant privileges of databse to user
SQL
0 vote357 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
17 votes354 views4 answers
Postgres list users
SQL
0 vote362 views1 answer
Mysql get hour from datetime
SQL
3 votes353 views1 answer
Oracle failed login attempts
SQL
0 vote329 views1 answer
Pip install mysqlclient error
SQL
0 vote326 views3 answers
Get count of null in column sql
SQL