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

35 votes147 views5 answers
Sql alter column
SQL
9 votes126 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote131 views1 answer
Mysql_error replacement
SQL
4 votes131 views1 answer
Restart for pg_hba.conf file
SQL
2 votes137 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote137 views1 answer
Data types mysql vs postgresql
SQL
0 vote96 views1 answer
Count char in java
SQL
0 vote138 views1 answer
Multiple tricky query in sql server
SQL
0 vote136 views3 answers
Group_concat sql server
SQL
-1 vote139 views3 answers
MySQL shutdown unexpectedly
SQL