Returned data with node js and mysql

Question

When i connect with mysql ,i get this value { id: 14 } actually i wanna get only 14 this is my code

app.get('/register',function(req,res){
    var data = {
        "error":1,
        "result":""
    };

    console.log("ams");
    connection.query("SELECT id from register",function(err, rows, fields){
        if(rows.length != 0){
            data["error"] = 0;
            data["result"] = rows;
            res.json(data);
            console.log(data.result[0]);
        }else{
            data["result"] = 'No data Found..';
            res.json(data);
        }
    });
});

yes, but it is simply the json data notation... can't you just read the json and see what is the value of the key "id"? — Piero Alberto
– Piero Alberto, Commented Feb 10, 2016 at 12:48
the value is 14 but i do not want to get the key every time i just want the value to access it later — amr hashem
– amr hashem, Commented Feb 10, 2016 at 12:50
dear @amrhashem, the Michael's solution you have accepted, is the same thing I have written here. — Piero Alberto
– Piero Alberto, Commented Feb 10, 2016 at 13:31

baao · Accepted Answer · 2016-02-10 12:49:39Z

1

If you're expecting one row only, you could set

data["result"] = rows[0].id;

However, your response is an array of json objects no matter how many results you get. It's much better to setup the res.json() receiver to work with objects, not plain strings/numbers.

It is not possible to get only values as a mysql query result in node with node-mysql (and I don't think there's any other library that would do that, because it doesn't make sense).

answered Feb 10, 2016 at 12:49

baao

73.5k18 gold badges151 silver badges208 bronze badges

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

2 Comments

amr hashem Over a year ago

i get this value { "error": 0, "result": 14 } but i want just the value not the key

baao Over a year ago

Then why do you set it in the first place? Return res.json(rows[0].id) if you're only interested in the value.

Collectives™ on Stack Overflow

Returned data with node js and mysql

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related