Node.js mysql response format

Question

I'm developing a node.js app which connects into a MYSQL database, gets some info, converts it into JSON format and write it into the browser.

I'm using the mysql npm (https://www.npmjs.org/package/mysql).

connection.query("select tact, digits, mode from table1 where id = '"+id+"'", function(err, rows, fields){
    if (err){
        console.log(err);
        throw err;
    }
    var objToJson = rows;
    objToJson.response = response;
    var finalresponse = JSON.stringify(objToJson);
});

And the final response is:

[{"tact":0,"digits":5,"mode":"on"}]

The point is that I only want to recieve something like (but it should be json parsed):

[{0,5,"on"}]

How could I do it? Is it possible?

Thanks guys.

Felix · Accepted Answer · 2014-04-08 19:14:20Z

1

To get each values into an array, iterate through it:

connection.query("select tact, digits, mode from table1 where id = '"+id+"'", function(err, rows, fields){
    if (err){
        console.log(err);
        throw err;
    }
    var objToJson = rows;
    var response = [];
    for (var key in rows) {
        response.push(rows[key]);
    }
    objToJson.response = response;
    var finalresponse = JSON.stringify(objToJson);
});

answered Apr 8, 2014 at 19:14

Felix

3412 silver badges10 bronze badges

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

Comments

user16603211 · Accepted Answer · 2022-03-31 13:14:19Z

0

According to W3Schools (https://www.w3schools.com/nodejs/nodejs_mysql_select.asp) the result can be queried like this:

console.log(result[2].address);

where address is a column in the dataset.

So since you have selected only 1 record:

let tact = result[0].tact;
let digits = result[0].digits;
let mode = result[0].mode

gives you the values you want as separate variable. or, you could put these into an array, and then work on.

Dermot

answered Mar 31, 2022 at 13:14

user16603211

Collectives™ on Stack Overflow

Node.js mysql response format

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related