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 vote218 views1 answer
Sqlite woth cmake
SQL
1 vote121 views1 answer
Mysql view curren querys
SQL
0 vote125 views3 answers
Delete in SQL SERVER
SQL
0 vote108 views1 answer
Error code 1241 mysql
SQL
23 votes125 views6 answers
Create table sql server
SQL
0 vote130 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote117 views1 answer
Mysql to get column name in database
SQL
0 vote72 views1 answer
Get last run query sql server
SQL
1 vote132 views2 answers
Sql queries practice
SQL
2 votes127 views3 answers
Current setting postgres timezone
SQL