node.js-MySQL COUNT the number of records

Question

I have following code.

var mysql = require('mysql'); var connection = mysql.createConnection({   host     : 'localhost',   user     : 'root',   password : '',   database : 'test' }); connection.connect();  var userdata = '24';  var sql = 'SELECT COUNT(*) FROM names WHERE age = ?' connection.query(sql, [userdata], function(err, rows, fields) {   if (err) throw err;   console.log('Query result: ', rows); });  connection.end(); 

I want to get the total number of records from table 'names' where 'age' = 24. I receive the following on my node.js command prompt.

Query result:  [ { 'COUNT(*)': '14' } ] 

My question is how to store this number 14 in a variable for further use.

I know I can do this just by changing the 'sql' line to

var sql = 'SELECT * FROM names WHERE age = ?' 

and then console line to

console.log('Query result: ', rows.length); 

But still is there another way?

Answer 1

Rewrite the

var sql = 'SELECT COUNT(*) FROM names WHERE age = ?' 

To look like, i.e.:

var sql = 'SELECT COUNT(*) AS namesCount FROM names WHERE age = ?' 

Then, you will get Query result: [ { 'namesCount': '14' } ].

so now you have

rows[0].namesCount 

Good enough?