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

24 votes218 views5 answers
List mysql users
SQL
0 vote199 views1 answer
Postgresql select fast check no rows
SQL
0 vote213 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote208 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote220 views1 answer
Sql multiple into
SQL
1 vote199 views1 answer
Mysql get character set
SQL
0 vote169 views2 answers
Delete the last item in a table sql
SQL
0 vote166 views0 answer
SQL
0 vote214 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
0 vote207 views1 answer
Close sql query vb.net
SQL