Store mysql Data in variable Node.js

Question

I am using mysql on node.js to get an id from some table .And now i wants to store that id in variable.

con.query("SELECT user_id FROM owners where id =?", [ownerId] , function (err, result, fields) {
    let id=result;
    console.log(id);
    if(err) throw err;
    //console.log(result);
    res.send(result);
});

I works perfectly and gets data from server but it stores th value in id is like [ RowDataPacket { user_id: 1642 } ]. But i want my id as only "1642" so that i can use some conditions. Kindl help

What about `result[0]. user_id`??? – Subburaj Oct 22 '19 at 05:25 — Subburaj, Oct 22 '19 at 05:25
still same result [ RowDataPacket { user_id: 1642 } ] – optikals app Oct 22 '19 at 05:28 — optikals app, Oct 22 '19 at 05:28

score 0 · Accepted Answer · answered Oct 22 '19 at 05:34

0

You can try for the following:

var parsedResult = JSON.parse(JSON.stringify(result));
let id = parsedResult[0].user_id;

answered Oct 22 '19 at 05:34

Subburaj

5,114
10
44
87

Worked For me thanks man – optikals app Oct 22 '19 at 05:38
Glad to help! Have a happy coding!!! – Subburaj Oct 22 '19 at 05:40

Store mysql Data in variable Node.js

1 Answers1