mysql select from 函数,试图使函数返回mysql'SELECT * FROM'结果，最终返回undefined

I'm trying to make a function that returns an array of stats from SQL 'SELECT * FROM', when I don't use a function to return it, it works, but I can't use that array outside of 'function(err, results)'

con.query(`SELECT * FROM MemberPeniz WHERE memberId = '${memberID}'`, function(err, results) {

if(err) {

throw err;

}

console.log(results)

})

I tried this:

function checkTimeoutMEMBERid(memberID) {

con.query(`SELECT * FROM MemberPeniz WHERE memberId = '${memberID}'`, function(err, results) {

if(err) {

throw err;

}

return results

})

}

const result = checkTimeoutMEMBERid(message.author.id);

console.log(result)

but as I say it returns undefined no matter what id I pass in

解决方案

This is because, you are returning results to callback which will not return to caller function. You can update function as,

function checkTimeoutMEMBERid(memberId) {

return new Promise((resolve, reject) =>{

con.query(`SELECT * FROM MemberPeniz WHERE memberId = ?`,[memberId], (err, results) => {

if(err) {

return reject(err)

}

resolve(results)

})

})

}

checkTimeoutMEMBERid(message.author.id)

.then(result =>

{

console.log(result)

})