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 vote179 views1 answer
Like sql for second letter of the family name
SQL
103 votes2.4K views1 answer
Like sql
SQL
0 vote208 views2 answers
Impala rename column name
SQL
0 vote237 views1 answer
Copy row from db to db mysql
SQL
4 votes179 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote198 views1 answer
Sql into vs insert into
SQL
0 vote191 views1 answer
Mysql terminal run sql file
SQL
1 vote191 views1 answer
Postgresql escape single quote
SQL
0 vote199 views1 answer
Create domain sql
SQL
0 vote147 views1 answer
Check if due date is less than todays date sql
SQL