mysql - Node.js updating column from array using loops

Question

I have an amount array that is created from req.body.amount. If I want to update the 'amount' column of my table using the elements from the array, can I do it using a loop like this:

amount.forEach(function (value) {
    let update = [value, req.body.name];
    let updatequery = "UPDATE food_item SET amount = ? WHERE name IN (?)";
    db.query(updatequery, update, (err, result) => {
        if (err) throw err;
    });
});

Do I also need another loop for the req.body.name array?

question from:https://stackoverflow.com/questions/65923152/node-js-updating-column-from-array-using-loops

Answer 1

yea u have to create a nested loop if you have an array like this: arr[4][4]

it will give a table like this:

you can update columb as follows:

for(let i = 0; i < n; i++){
   for(let j = 0; j < n; j++){
      arr[i][j] = value;
   }
}