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

3 votes130 views1 answer
Oracle get trigger ddl
SQL
0 vote136 views1 answer
Regex any word except sql
SQL
0 vote133 views1 answer
Mysql set boolean default value
SQL
0 vote144 views1 answer
Flask sqlalchemy session delete
SQL
8 votes133 views1 answer
How to check mysql version in xampp
SQL
0 vote124 views1 answer
How to reset table in sql server
SQL
0 vote175 views1 answer
Sqlite display headers on columns
SQL
4 votes157 views2 answers
Postgresql float data type
SQL
0 vote126 views1 answer
Add alternate add column sql
SQL
0 vote146 views1 answer
Mysql wsrep ls
SQL