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

11 votes317 views4 answers
Round in sql
SQL
0 vote190 views1 answer
Alternative for LIMIT sql
SQL
0 vote141 views1 answer
Mysql subdate
SQL
0 vote137 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote138 views1 answer
Show function mysql
SQL
0 vote136 views1 answer
C# mysql update statement set value to null
SQL
24 votes165 views4 answers
Delete db postgres
SQL
0 vote164 views1 answer
In query in sql
SQL
0 vote146 views1 answer
Ver usuarios mysql
SQL
0 vote135 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL