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

3 votes201 views1 answer
Oracle undo tablespace schema
SQL
0 vote193 views1 answer
Pagination with row_number
SQL
10 votes175 views5 answers
Create table mysql query
SQL
2 votes177 views1 answer
Sql find missing values between two tables
SQL
5 votes206 views1 answer
Oracle nls parameters
SQL
0 vote194 views1 answer
Get last updated row sql server
SQL
0 vote191 views3 answers
Magento 2 order delete from db
SQL
0 vote183 views2 answers
Sql query inner join 3 tables
SQL
0 vote180 views1 answer
Mysql multiple primary keys
SQL
0 vote162 views1 answer
Sql examples from your work
SQL