Cannot use SELECT SQL statement in NODE,js

Question

I am trying to output a list of all the items from a MYSQL table to the console while using Node JS however when trying to use the code it gives me the error thata Callback function is not available with promise clients (the database connection is a promise as it is SSH tunnelled back to our university) any help with this would be really useful!!

 var database = require('./dbConfig');
database.then((con) => {
    con.query('SELECT * FROM Pupils', (err, rows) => {
        console.log(rows)
    })
})

Try con.query('SELECT * FROM Pupils').then(result => console.log(result)) — Ihor Sakailiuk
– Ihor Sakailiuk, Commented Jan 14, 2021 at 15:37
Thank you!! This Worked but now it outputs a Column Definition in the console for all columns in the table, is there a way to stop this? — Harry Wright
– Harry Wright, Commented Jan 14, 2021 at 15:45
con.query('SELECT * FROM Pupils').then(([result]) => console.log(result)) — Ihor Sakailiuk
– Ihor Sakailiuk, Commented Jan 14, 2021 at 16:30

user2399035 · Accepted Answer · 2021-01-14 15:39:05Z

1

I'd do:

await database.promise().query("SELECT * FROM Pupils")
    .then( ([rows,fields]) => {
        //return your results
    })
    .catch(console.log)

Collectives™ on Stack Overflow

Cannot use SELECT SQL statement 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