rn3w rn3w - 6 months ago 23
Node.js Question

i have a function mysql in nodejs and can't parsear the result

My function is:

objBD.query('SELECT MAX(ID_U) FROM usuario', function(err, rows, fields) {

The result is


I need the max number, example: 43


The rows variable returned by mysql's callback is an array, even if the result is only one row (as in the case of using max). To access the result you should access the first row of the array, as in:


It will likely give an output of: {'MAX': 43}