Description
Update rows in a table matching a where clause.
db_update · action · Database · Available · v1.0.0
Update rows in a table matching a where clause.
Fields shown in the editor when configuring the node. Generated directly from the NodeDefconfigFields.
| Field | Type | Required | Default | Description |
|---|---|---|---|---|
databaseIdDatabase | db-picker | yes | — | — |
tableTabella | db-table-picker | yes | — | — |
whereJsonRiga da aggiornare (WHERE) | key-value | yes | — | Coppie chiave-valore: la riga deve matchare tutte. Es. id = 42. |
patchJsonCampi da modificare | key-value | yes | — | Coppie chiave-valore dei campi da aggiornare. Supporta {{espressioni}}. |
JSON snippet of the node as it appears in the workflow. Values are derived fromdefaultValue and from required parameters.
{
"id": "node-db_update-1",
"defId": "db_update",
"label": "DB: Update",
"config": {
"databaseId": "<databaseId>",
"table": "<table>",
"whereJson": "<whereJson>",
"patchJson": "<patchJson>"
}
}Available now on all FlowForge plans. Try it free without a credit card.
Start freeBrowse all nodes