Print only JSON Values returned from MySql query in nodejs

Question

I want to retrieve records from mysql and display data on my page coded in nodejs with format

 [
    ["1262889000000",788,803,783.3,795.65],
    ["1262889000000",788,813,783.3,795.65],
    ["1451500200000",2.85,13,1.05,1.1],
    ........
 ]

my table schema

Column1           |   col2   |   col3   |    col4     |   col5

1262889000000          788       783.3        794          65  
1262889000000          788       813.7        795          65 
...........
...........

Here is my nodejs code

app.get('/charts/sample1', function(req, res) {

    con.query("select col1,col2,col3,col4,col5 from table1", function(err, data) {
    res.send(data);
    }); 

 });

however currently when run my code i get out in json alng with {key1:value,key2:value,...},

Terry Lennox · Accepted Answer · 2018-04-20 09:57:47Z

2

So you want to map the object values in each row to an array?

Something like this? :

var rows = [{
    Column1: 1262889000000,
    col2: 788,
    col3: 783.3,  
    col4: 794,
    col5: 65
}];

var result = rows.map((row) => {
    return Object.values(row);
});

console.log(result);

Here's a JSFiddle for this: https://jsfiddle.net/y0vpad3b/

answered Apr 20, 2018 at 9:57

Terry Lennox

30.9k5 gold badges36 silver badges45 bronze badges

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

1 Comment

Terry Lennox Over a year ago

Cool, glad to help!!

Collectives™ on Stack Overflow

Print only JSON Values returned from MySql query in nodejs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related