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

0 vote245 views1 answer
Radius search with point data in mysql
SQL
8 votes225 views1 answer
Oracle search source code
SQL
0 vote260 views1 answer
Generate sql from specific migration ef core
SQL
0 vote230 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote267 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote226 views1 answer
Implizite joins sql
SQL
1 vote296 views1 answer
Difference between where and having clause
SQL
1 vote244 views1 answer
Vagrant mysql downgrade version
SQL
2 votes227 views1 answer
Get first 2 letter in sql
SQL
0 vote208 views1 answer
What are the aggregate function in sql
SQL