Heliont MySQLInstall

Summary

Updates rows in a MySQL table based on a match column/value, using either auto‑mapped input fields or manually defined column/value pairs.

Inputs

• Incoming Items — Each item supplies data for the UPDATE. In Auto‑Map mode, item property names must match target table column names (except the match column). In Define Below mode, the Values to Send list defines which columns to set.

Output shape

array of items

Each incoming item is passed through. When Detailed Output is enabled, each item includes extra fields such as the executed query, query type, number of rows affected, and raw result.

Examples

Example 1: Auto‑Map update

Table: users; Data Mode: Auto-Map Input Data to Columns; Column to Match On: id; Value of Column to Match On: {{$json["id"]}}; Options: Query Batching: Independent.

Example 2: Define Below update with batching

Table: orders; Data Mode: Map Each Column Below; Column to Match On: order_id; Value of Column to Match On: 123; Values to Send: [{Column: status, Value: shipped}, {Column: updated_at, Value: {{$now}}}]; Options: Query Batching: Single Query; Replace Empty Strings with NULL: true.