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

1 vote112 views1 answer
Encrypt password postgresql
SQL
0 vote116 views1 answer
Codeigniter 3 get best-selling products
SQL
0 vote111 views1 answer
Microsoft word insert sql code
SQL
54 votes190 views6 answers
Sql rename column
SQL
0 vote112 views1 answer
How to print out column name differently in mysql
SQL
2 votes122 views4 answers
2nd highest salary in mysql
SQL
1 vote123 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote132 views1 answer
Alter domain sql
SQL
3 votes116 views1 answer
Set default today mysql
SQL
3 votes126 views2 answers
Brew restart mysql
SQL