mysql - Nodejs mysql 选择响应

Question

**如何从输出中删除双引号**

    app.get('/yearexpense',(req,res)=>{
mysqlConnection.query('SELECT login.display_name AS label, group_concat( daily_expenses.amount) AS data FROM login JOIN daily_expenses ON login.id = daily_expenses.user GROUP BY daily_expenses.user',(err,rows,fields)=>{
    if(!err)

        res.send(rows); 
})

});

预期输出

[
  { data: [330, 600], label: 'Ravi' },
  { data: [120, 455], label: 'Amit' },
  { data: [45, 67], label: 'Roshan' }
];

获取输出

[{"label":"Ravi Kanti","data":"[314,444]"},{"label":"Amit prakash","data":"[78]"},{"label":"Roshan Kumar","data":"[215,80,165]"}]

Answer 1

query() 回调中的 rows 变量包含预期结果。

W3Schools 有一些示例: https://www.w3schools.com/nodejs/nodejs_mysql_select.asp