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

16 votes148 views3 answers
Update table from another table
SQL
13 votes142 views2 answers
Get tables in database sql
SQL
0 vote109 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote172 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
3 votes157 views1 answer
Oracle apex message quit website
SQL
0 vote141 views1 answer
Get number of table colums in sql query
SQL
0 vote144 views1 answer
Frename oracle
SQL
0 vote148 views1 answer
Mysql database hyphen
SQL
4 votes137 views2 answers
Sql table
SQL
1 vote146 views3 answers
Sql union
SQL