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 vote353 views3 answers
Run sql command line
SQL
7 votes327 views1 answer
Set sequence value oracle
SQL
1 vote324 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote367 views1 answer
How to find all children of a record with only parent ID in sql
SQL
3 votes368 views1 answer
Sql double index
SQL
0 vote333 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote339 views1 answer
Sql menampilkan data tabel
SQL
0 vote326 views1 answer
Mysql change timestamp on update
SQL
3 votes374 views2 answers
Truncate table
SQL
0 vote331 views2 answers
Sql query in dax power bi
SQL