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 vote139 views1 answer
Get all employee of salary if more than in sql
SQL
1 vote151 views2 answers
Pad zero sql server
SQL
3 votes149 views2 answers
Plsql print
SQL
0 vote163 views1 answer
Sql getdate minus 1 day without time
SQL
2 votes169 views2 answers
Mysql add hours to time field
SQL
3 votes245 views2 answers
Savepoint in sql
SQL
1 vote148 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote158 views1 answer
Oracle sql drop table
SQL
0 vote146 views1 answer
Mysql workbench view
SQL
0 vote181 views1 answer
Mysql get hour from datetime
SQL