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 votes322 views1 answer
Python sql
SQL
0 vote272 views1 answer
Mysql identified by syntax error
SQL
-2 votes276 views1 answer
Use of where in left join in mysql
SQL
6 votes271 views2 answers
Drop foreign key
SQL
49 votes362 views6 answers
Install mysql ubuntu
SQL
0 vote283 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote285 views1 answer
Last date for each user sql
SQL
0 vote278 views1 answer
Sequelize postgresql schema
SQL
0 vote284 views1 answer
How to Remove milliseconds from Date time
SQL
1 vote300 views1 answer
Postgresql substring last
SQL