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

3 votes298 views1 answer
Mysql UPDate with enner join
SQL
0 vote331 views1 answer
Get initials name in sql
SQL
2 votes319 views1 answer
Oracle calculated column
SQL
1 vote333 views1 answer
Random name function in mysql for nvarchar
SQL
11 votes306 views2 answers
Set default column value sql
SQL
2 votes304 views1 answer
Anonymous block plsql
SQL
1 vote339 views3 answers
Alter schema sql server
SQL
0 vote325 views1 answer
Sql server select record with max id
SQL
4 votes324 views2 answers
Linq join
SQL
0 vote304 views1 answer
Uuid sqlalcomany
SQL