Empresas
Empleos
  • Sobre nosotros
  • Soluciones
    • Publicación de vacantes
      Publica tu vacante y recibe candidatos calificados en 48h.
    • Evaluación de candidatos
      500+ pruebas técnicas y psicológicas, más anti-fraude.
    • Headhunting
      Búsqueda ejecutiva a la medida de principio a fin.
    • Nómina + EOR
      Dispersión de nómina y EOR en más de 15 países de LATAM.
  • Precios
  • Empleos

0

475
Vistas
Store MySql query output in a variable (Node js)

I want to make an sql query and want to store the output in a variable. I can't find any solution to make that work, can anyone help me please?

const { createPool } = require("mysql")

const pool = createPool({
    host:"localhost",
    user:"root",
    password:"",
    database:"ticketsystem",
    connectionLimit:10
})

const h = pool.query("select * from tblusers;", (err, res) => {
    return res
})

console.log(h)

about 4 years ago · Juan Pablo Isaza
1 Respuestas
Responde la pregunta

0

Your problem is related to the asynchronous nature of the JavaScript execution: the code located in the pool.query's callback function runs after the assignation of the h variable and after the console.log.

You have 2 options:

  1. You can place your entire follow up code inside the callback function:
pool.query("select * from tblusers;", (err, res) => {
  const h = res
  // do whatever comes next here...
})
  1. Promisify the result of the callback function and await its resolution before moving on
const h = await new Promise((resolve) => {
  pool.query("select * from tblusers;", (err, res) => {
    resolve(res)
  })
})

console.log(h)
// do whatever comes next here...

Note that if you are not using one of the latest versions of node (supporting top level await), you will have to place everything in an IIFE function:

(async () => {
  const pool = createPool({
    host:"localhost",
    user:"root",
    password:"",
    database:"ticketsystem",
    connectionLimit:10
  })

  const h = await new Promise((resolve) => {
    pool.query("select * from tblusers;", (err, res) => {
      resolve(res)
    })
  })

  console.log(h)
  // do whatever comes next here...
})()
about 4 years ago · Juan Pablo Isaza Denunciar
Responde la pregunta
Encuentra empleos remotos

¡Descubre la nueva forma de encontrar empleo!

Top de empleos
Top categorías de empleo
Empresas
Publicar vacante Precios Comercial
Legal
Términos y condiciones Política de privacidad
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Recomiéndame algunas ofertas
Necesito ayuda