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 vote355 views1 answer
Error code 1175 mysql fix
SQL
13 votes357 views2 answers
Get tables in database sql
SQL
1 vote325 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote403 views2 answers
How to drop mili second in sql
SQL
6 votes362 views2 answers
Drop foreign key
SQL
2 votes384 views1 answer
Postgresql create table as select
SQL
0 vote366 views1 answer
Alter boolean column postgresql
SQL
8 votes368 views1 answer
Today minus 15 days postgresql
SQL
-1 vote380 views1 answer
Concat two columns in sql server
SQL
10 votes347 views2 answers
Sql merge statement
SQL