I am looking to format the MySQL result in Node.js in a specific way. The desired result format should look like this:
[
{
"m_idx" :1 ,
"contents" :
{
"m_name" : "a",
"m_name" : "b",
}
},
"m_idx" :2,
"contents" :
{
"m_name" : "c",
}
}
]
However, my current result does not match this formatting. It looks like this:
{
"m_idx": 1,
"contents": [
{
"m_name": "a"
}
]
},
{
"m_idx": 1,
"contents": [
{
"m_name": "b"
}
]
},
I am unsure of how to achieve the desired result. Can anyone provide assistance? Below is the code that I have been working on:
let result = [];
let categories = [];
connection.query(sql, function (err, rows) {
if (res.status(200)) {
rows.forEach(function (row, index) {
let variable = {
m_idx: row.m_idx,
contents: []
};
categories.push(variable);
variable.contents.push({
m_name: row.m_name,
name: row.name,
})
});
res.json(categories);
}
});
This is an example of the data structure in my database:
-----
|1|a|
|1|b|
|2|c|
-----