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

6 votes154 views2 answers
Mysql get yesterday
SQL
0 vote156 views1 answer
Selects all the columns from the sailors table
SQL
1 vote198 views1 answer
Postgres select as csv
SQL
0 vote156 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote153 views1 answer
Partition by sql server
SQL
3 votes161 views3 answers
Stop mysql ubuntu
SQL
1 vote171 views2 answers
Mysql limit offset
SQL
16 votes157 views4 answers
Ascending order mysql
SQL
0 vote163 views1 answer
Sql values that contains certain multiple ids
SQL
1 vote155 views1 answer
Sql get missing id
SQL