mariadb - Node.js Mariasql Count result not useful -

mariadb - Node.js Mariasql Count result not useful -

i don't become useful result count query.

here wonderful code.

var inspect = require('util').inspect; var client = require('mariasql'); var c = new client(); c.connect({ host: '127.0.0.1', user: 'root', password: 'xx', db: 'node' }); c.query("select count(id) addresses;") .on('result', function(res) { res.on('row', function(row) { console.log(row); // problem row.id, row.count or row.count.id don't works }) .on('error', function(err) { console.log('result error: ' + inspect(err)); }) .on('end', function(info) { console.log('result finished successfully'); }); }) .on('end', function() { console.log('done results'); }); c.end();

my output is

[cseipel@myhost test]$ node counter.js { 'count(id)': '6' } result finished successfully> done results

but need "6" line 2

try including more useful column name in query, example: select count(id) count addresses. within 'row' event should have row.count value.

node.js mariadb