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 vote213 views1 answer
Primary key start from number
SQL
0 vote183 views1 answer
How to start my sql server on mac
SQL
3 votes229 views1 answer
Sql online test questions and answers
SQL
0 vote196 views1 answer
How to check replication lag in mySQL
SQL
1 vote188 views1 answer
Temp table vs variable table in sql server
SQL
44 votes309 views4 answers
Mysql alter table add column first
SQL
0 vote148 views2 answers
Sql query unique
SQL
1 vote2.7K views1 answer
Dropping a constraint in ms sql
SQL
13 votes190 views5 answers
Alter table query sql server change column
SQL
1 vote196 views1 answer
Convert varchar to int in sqlite
SQL