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

13 votes159 views2 answers
Check if value is null mysql
SQL
0 vote346 views1 answer
Get first match in each group mysql query
SQL
1 vote166 views1 answer
Moodle query item quiz
SQL
-1 vote188 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote173 views1 answer
Java nosql sort
SQL
0 vote173 views1 answer
Sql find gaps in date ranges
SQL
0 vote186 views1 answer
Mysql sleep connections
SQL
1 vote161 views1 answer
How to select random rows from table
SQL
0 vote169 views1 answer
Pip install mysqlclient error
SQL
0 vote210 views1 answer
Mysql show schema
SQL