select mysql COUNT value in nodejs

Question

Mysql query looks like this

const numOfReplies = await SQL('SELECT COUNT(conversation_id), conversation_id FROM tweet_replies GROUP BY conversation_id')

so there are multiple rows with the same conversation_id, and i want to get a number of rows for every conversation_id. After looping with forEach

numOfReplies.forEach(num => {
  console.log(num)
})

response looks like this

{
  'COUNT(conversation_id)': '10',
  conversation_id: '1530169643423367169'
}
{
  'COUNT(conversation_id)': '10',
  conversation_id: '1530172022357106690'
}

how can i select value of COUNT(conversation_id) from this response?

Alaindeseine · Accepted Answer · 2022-06-02 08:15:16Z

1

Simply name the COUNT value in SQL request with AS keyword and get it like a field :

SELECT COUNT(conversation_id) AS myCount, conversation_id FROM tweet_replies GROUP BY conversation_id

You will get response like this:

{
  myCount: '10',
  conversation_id: '1530169643423367169'
}
{
  myCount: '10',
  conversation_id: '1530172022357106690'
}

answered Jun 2, 2022 at 8:15

Alaindeseine

4,6341 gold badge17 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

select mysql COUNT value in nodejs

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related