How to access RowDataPacket mysql-node.js

Question

connection.query('
SET @update_id := 0; 
UPDATE relations set x1 = ?, y1 = ?, id = (SELECT @update_id := id) WHERE element_to =?;
SELECT @update_id;',[data.x2,data.y2,id],function(err,result){
if(err){console.error(err);}
else{console.log(result);console.log(result.@update_id);}
});

I am getting the following result from a query execution:

[ RowDataPacket {
  '@update_id': 'WAbWA1WA5WA2WA8WAdWA4WA9' } ] ]

How do I access the @update_id field to store the value in a variable. I know these are objects and I tried the following to access them such as follows:

results.@update_id;

But I get undefined when I try to log the value. How to get the value?

Possible duplicate of [How to access a RowDataPacket object](https://stackoverflow.com/questions/31221980/how-to-access-a-rowdatapacket-object) — Damjan Pavlica, Aug 01 '18 at 17:20

score 18 · Accepted Answer · answered Jul 01 '16 at 07:15

18

Try this:

results[0].@update_id

answered Jul 01 '16 at 07:15

Lalit Goswami

798
1
8
21

score 2 · Answer 2 · edited Feb 02 '19 at 16:01

2

use console.log(JSON.stringify(result));

then if you want to get access data on variable

var data = JSON.stringify(result[0].@update_id)
console.log(data);

you can't use index on var E.G

console.log(data[0].@update_id) it is wrong

edited Feb 02 '19 at 16:01

Ruslan

6,090
1
21
36

answered Feb 02 '19 at 14:10

nazir

21
1

score 2 · Answer 3 · answered Oct 07 '20 at 09:29

2

just conver the result to array, then you can easily access the data, i get solved by doing this

let res = JSON.parse(JSON.stringify(result));

answered Oct 07 '20 at 09:29

ahsan dev

31
2

How to access RowDataPacket mysql-node.js

3 Answers3