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 vote253 views1 answer
Postgresql create table with boolean column
SQL
7 votes271 views2 answers
Oracle sql drop index
SQL
0 vote278 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote267 views1 answer
Get relation data in mysql using query to excel
SQL
7 votes319 views3 answers
Sql server check if temp table exists
SQL
0 vote296 views1 answer
Add super privilege mysql
SQL
8 votes286 views4 answers
Postgresql server restart
SQL
0 vote267 views1 answer
Mysql min value row
SQL
0 vote254 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
1 vote276 views1 answer
Oracle previous year
SQL