How to store "count(*)" value in a variable in NodeJS?

Question

I want to store the result of count (ex:- 5) in MySQL query to a variable, but it is storing the whole JSO string as [{"COUNT(*)":8}], so How to store value 8 in my variable row?

My code in NodeJS:

connection.query('SELECT COUNT(*) FROM issues',
            function(err, rows){
            var row=JSON.stringify(rows);
            console.log(row);

            });

use alias: SELECT COUNT(*) as cnt ...

vp_arth
– vp_arth

2015-07-31 14:14:14 +00:00
Commented Jul 31, 2015 at 14:14 — vp_arth
– vp_arth, Commented Jul 31, 2015 at 14:14

dimpiax · Accepted Answer · 2017-09-19 13:27:12Z

8

Use sql alias:

connection.query('SELECT COUNT(*) AS count FROM issues', (err, rows) => {
    const count = rows[0].count;
    // const count = rows[0]['COUNT(*)']; // without alias
    console.log(`count: ${count}`);
});

edited Sep 19, 2017 at 13:27

dimpiax

12.7k5 gold badges68 silver badges48 bronze badges

answered Jul 31, 2015 at 14:16

vp_arth

15k4 gold badges43 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ralh · Accepted Answer · 2015-07-31 14:21:01Z

1

Simply extract the value from the rows object by key. rows[0]['COUNT(*)'] should work. Do that before you stringify it.

EDIT: As the comment below pointed out, rows is an array. Edited answer.

edited Jul 31, 2015 at 14:21

answered Jul 31, 2015 at 13:32

ralh

2,5941 gold badge16 silver badges19 bronze badges

1 Comment

vp_arth Over a year ago

You forgot about rows is an array :)

Collectives™ on Stack Overflow

How to store "count(*)" value in a variable in NodeJS?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related