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 vote140 views1 answer
Convert rows to columns in sql server
SQL
0 vote162 views1 answer
Mariadb create index if not exists
SQL
0 vote155 views1 answer
Plsql find location of procedure
SQL
6 votes135 views1 answer
Rank function in oracle with example
SQL
0 vote146 views1 answer
Addition of 2 column value in mysql
SQL
-1 vote144 views1 answer
Ssql to lowercqse
SQL
0 vote167 views1 answer
Find how many tables in database sql query
SQL
17 votes179 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote155 views3 answers
Query string not ending with with vowels
SQL
2 votes153 views1 answer
Q operator in sql
SQL