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 votes329 views1 answer
How to insert string variable into sqlite database
SQL
2 votes331 views2 answers
Run mysql command from bash
SQL
0 vote345 views1 answer
How to write if case in select query in select statement
SQL
7 votes337 views1 answer
Sql disable safe mode
SQL
15 votes484 views2 answers
Sql order by alphabetical
SQL
0 vote322 views1 answer
Add column to table with default value plsql
SQL
0 vote331 views1 answer
Sql server create constraint
SQL
0 vote380 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
1 vote310 views1 answer
Postgres regex remove special characters
SQL
0 vote319 views1 answer
Trigger value from maltiple table to single table mysql
SQL