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 vote311 views1 answer
C# sql transaction multiple connections
SQL
2 votes277 views2 answers
How to check data type in sql server
SQL
9 votes260 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote257 views1 answer
Sql roll up rows into columns
SQL
0 vote264 views1 answer
Concat column value of same user in mysql
SQL
0 vote301 views1 answer
Oracle session statistics
SQL
1 vote322 views1 answer
Mysql default port
SQL
5 votes262 views1 answer
Mysql change primary key
SQL
0 vote256 views1 answer
MySQL error code 2068
SQL
0 vote284 views1 answer
Sql update subtract value
SQL