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 vote370 views1 answer
Mysql page segment
SQL
0 vote372 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
2 votes354 views1 answer
How to get weekday from old date in sql
SQL
1 vote346 views1 answer
User privileges postgresql information_schema
SQL
2 votes367 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote343 views1 answer
Soql more than today
SQL
3 votes369 views2 answers
Sql server current date without time
SQL
0 vote370 views1 answer
Add a new column into table
SQL
8 votes392 views2 answers
Update sql server from another table
SQL
0 vote407 views1 answer
Mariadb cast to int
SQL