How to make an async function with mysql in node.js

Question

I try to store the result of my mysql request into and async function (to make something after storing my result) but it's returning undefined.. I don't know why

function hh () {
  connection.query('SELECT * FROM `rounds` ', function (error, results, fields) {
    if (error) throw error;
    // console.log(results)
    return results
  });
}

async function run() {
  connection.connect();
  let deter = await hh();
  console.log(deter)
  connection.end();
}

run();

BENARD Patrick · Accepted Answer · 2019-12-20 14:51:30Z

1

You're not returning a promise... Try with this code, it could help...

function hh () {
  return new Promise((resolve, reject) => {
      connection.query('SELECT * FROM `rounds` ', function (error, results, fields)   {
          if (error) return reject(error);
          // console.log(results)
          resolve(results)
      });
  });
}

async function run() {
  connection.connect();
  let deter = await hh();
  console.log(deter)
  connection.end();
}

run();

answered Dec 20, 2019 at 14:51

BENARD Patrick

31k16 gold badges104 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to make an async function with mysql in node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related