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

9 votes282 views3 answers
Mysql run sql file
SQL
0 vote234 views1 answer
Select value from previous row in postgresql
SQL
22 votes333 views1 answer
Mysql workbench
SQL
0 vote291 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote254 views1 answer
How get data from database if id not found then search another column
SQL
0 vote259 views1 answer
Query archive mode
SQL
0 vote261 views2 answers
Search stored procedures by name
SQL
0 vote255 views1 answer
Mysql sql select one day before
SQL
0 vote260 views1 answer
Populate db from command line postgres
SQL
0 vote246 views1 answer
Truncate table sql server foreign key
SQL