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 votes197 views1 answer
Use cases condition in sql query laravel
SQL
0 vote187 views1 answer
Mysql check datetime equals date
SQL
0 vote240 views1 answer
Postgres rename database
SQL
4 votes199 views1 answer
Phone number sql
SQL
0 vote180 views1 answer
Dapper run sql script with parameters
SQL
0 vote231 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote189 views1 answer
Postgresql function ROUND
SQL
9 votes193 views1 answer
Sql server get utc date
SQL
3 votes194 views1 answer
Oracle transaction commit rollback example
SQL
0 vote170 views1 answer
Oracle list chain steps
SQL