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 vote295 views3 answers
Sql delete all except
SQL
-1 vote292 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote284 views1 answer
How to find database collation in postgres
SQL
0 vote292 views2 answers
Azure sql-datenbank
SQL
0 vote295 views1 answer
How to get data between a last week in mysql
SQL
16 votes304 views1 answer
Mysql smallint range
SQL
1 vote308 views1 answer
How to show index type in postgresql
SQL
11 votes328 views2 answers
Oracle source code
SQL
7 votes269 views2 answers
Create mysql user
SQL
3 votes322 views2 answers
Check data in table mysql
SQL