How to UPDATE a mySQL table with JSON Object in Node.js?

Question

I have a JSON Object and want to UPDATE a mySQL table, without List all of the Keys

with an INSERT I do this like

    var arrayValue = Object.keys(obj).map(function(key) {
      return String("'"+obj[key]+"'");
    });

    var arrayKeys = Object.keys(obj).map(function(key) {
      return String(key);
    });
    var sql = "INSERT INTO `modules` "+ " (" +arrayKeys.join() + ") VALUES ("+arrayValue.join()+");";
    con.query(sql, function (err, result, fields) {
      if (err) throw err;
      return result;
    });

The same i would do with UPDATE

How can i do this?

Can you update the question with the JSON object and what exactly would be your update query is mysql from that json object. — ambianBeing
– ambianBeing, Commented Nov 22, 2019 at 20:05

Laurent Dhont · Accepted Answer · 2019-11-24 19:39:29Z

4

does this fill your needs?

const object = {
    id: 1,
    firstName: "John",
    lastName: "Doe"
};

const columns = Object.keys(object);
const values = Object.values(object);

let sql = "INSERT INTO tableName ('" + columns.join("','") +"') VALUES (";

for (let i = 0; i < values.length; i++) {
    sql += "?";
    if (i !== values.length - 1) {
        sql += ",";
    }
}

sql+= ")";

connection.query(sql, values, (error, result, fields) => {
    //do what you must here.
});

For update:

const object = {
    id: 1,
    firstName: "John",
    lastName: "Doe"
};

const columns = Object.keys(object);
const values = Object.values(object);

let sql = "UPDATE tableName SET '" + columns.join("' = ? ,'") +"' = ?";

connection.query(sql, values, (error, result, fields) => {
    //do what you must here.
});

Off course what would you put in the where statement?

I hope this helped.

edited Nov 24, 2019 at 19:39

answered Nov 22, 2019 at 19:50

Laurent Dhont

1,0722 gold badges13 silver badges23 bronze badges

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

Comments

Federico Marilungo · Accepted Answer · 2020-05-10 08:01:52Z

2

here the example

/ Update an existing user
app.put('/users/:id', (request, response) => {
    const id = request.params.id;

    pool.query('UPDATE users SET ? WHERE id = ?', [request.body, id], (error, result) => {
        if (error) throw error;

        response.send('User updated successfully.');
    });
});

that works for me

answered May 10, 2020 at 8:01

Federico Marilungo

212 bronze badges

1 Comment

Federico Marilungo Over a year ago

code.tutsplus.com/tutorials/…

Collectives™ on Stack Overflow

How to UPDATE a mySQL table with JSON Object in Node.js?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related