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 vote298 views2 answers
Mysql password error create datbase
SQL
0 vote336 views1 answer
Bitmap join index
SQL
0 vote284 views1 answer
What is the essence of SQL?
SQL
-1 vote312 views1 answer
Partial search in sql
SQL
0 vote400 views1 answer
Sqlite display data in separated columns
SQL
3 votes266 views1 answer
How to get list of synonyms in oracle
SQL
1 vote308 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
4 votes317 views4 answers
What is primary key
SQL
1 vote327 views1 answer
Update foreign key value in mysql
SQL
1 vote297 views1 answer
Funzioni plsql
SQL