Node.js从MySQL查询返回结果

您只需要对回调中的db查询结果进行处理。就像。

function getColour(username, roomCount, callback){    connection.query('SELECt hexpre FROM colours WHERe precedence = ?', [roomCount], function(err, result)    {        if (err)  callback(err,null);        else callback(null,result[0].hexpre);    });}//call Fn for db query with callbackgetColour("yourname",4, function(err,data){        if (err) { // error handling pre goes here console.log("ERROR : ",err);         } else {  // pre to execute on data retrieval console.log("result from db is : ",data);}});