# mySQL, update 2 cells

**URL:** <https://discourse.nodered.org/t/mysql-update-2-cells/84044>\
**Category:** General\
**Created:** [26 December 2023 17:59 UTC](https://discourse.nodered.org/t/mysql-update-2-cells/84044 "2023-12-26T17:59:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![druckstick.at](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@druckstick.at](https://discourse.nodered.org/u/druckstick.at)\
**Post date:** [26 December 2023 17:59 UTC](https://discourse.nodered.org/t/mysql-update-2-cells/84044/1 "2023-12-26T17:59:34Z")

</div>

Hello everybody!  
I know how to update a cell with the mySQL node:

```auto
msg.topic = "UPDATE Tabelle1 SET Column1 = '" + msg.payload.value1+ "' WHERE Zeilen_ID = " + "'" + msg.payload.ID+ "'";;
    
return msg;

```

But how can I update two cells at the same time?  
Column1 = value1  
Column2 = value2

I tried the following, but unfortunately it doesn't work:

```auto
msg.topic = "UPDATE Tabelle1 SET (Column1, Column2) " +
    "VALUES ( " + msg.payload.value1 + ", " + msg.payload.value2 + ")"
    WHERE Zeilen_ID = " + "'" + msg.payload.ID + "'";;
  
return msg;

```

Can anyone help here?

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [26 December 2023 18:26 UTC](https://discourse.nodered.org/t/mysql-update-2-cells/84044/2 "2023-12-26T18:26:32Z")

</div>

I think you should be aiming at  
`UPDATE table SET column1 = value1, column2 = value2 WHERE column3 = id`

However it is not good practise to include the values in msg.topic, better to use prepared queries like this

```auto
msg.topic = "UPDATE mytable SET temperature = ?, humidity = ?, location = ? WHERE id = 100"
msg.payload = [17, 85, "door"] // An array of values to substitute for ? marks in msg.topic

```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [9 January 2024 18:26 UTC](https://discourse.nodered.org/t/mysql-update-2-cells/84044/3 "2024-01-09T18:26:35Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.