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

2 votes299 views2 answers
MySql FULL OUTER JOIN
SQL
0 vote185 views1 answer
Xamarin sql lite create table if not exist
SQL
1 vote212 views1 answer
Sql server if exists update else insert
SQL
0 vote171 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote174 views1 answer
Mariadb cast null to 0
SQL
2 votes169 views3 answers
Current month mysql query
SQL
0 vote174 views1 answer
Delete * from where id = 1;
SQL
0 vote208 views1 answer
Mysql command line top 10
SQL
0 vote233 views1 answer
Sqlalchemy query return only n results
SQL
0 vote188 views1 answer
Helptext in sql
SQL