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 vote251 views2 answers
Mysql cast to varchar
SQL
13 votes223 views2 answers
Oracle inner join
SQL
0 vote189 views1 answer
Mysql undo delete
SQL
0 vote198 views1 answer
Sql remove first character from string
SQL
3 votes201 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote239 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
1 vote189 views2 answers
Oracle difference between two dates in seconds
SQL
1 vote212 views1 answer
Mysql find most common value
SQL
3 votes183 views1 answer
Search for column name in psql
SQL
2 votes231 views3 answers
How do I add a user to a postgres database? cli
SQL