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 vote335 views1 answer
Pagination with row_number
SQL
3 votes279 views2 answers
Pl sql escape '
SQL
2 votes298 views1 answer
How to get non distinct values in sql
SQL
0 vote278 views2 answers
Mysql add days to date
SQL
-1 vote303 views1 answer
Sql select data from one database and insert into a different database
SQL
5 votes287 views1 answer
Purge undo tablespace oracle 11g
SQL
2 votes302 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote271 views3 answers
Default password of mysql
SQL
0 vote291 views1 answer
C# add a textbox in mysql select
SQL
0 vote272 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL