Heliont MySQLInstall

Summary

Inserts a new row or updates an existing row in a MySQL table based on a matching column (upsert).

Inputs

• item — Each incoming item contains data to be inserted or updated. When Data Mode is Auto-Map Input Data, the item's JSON property names must match column names; when Data Mode is Map Each Column Below, the values are taken from the node's manual field definitions.

Output shape

single

Results are returned on the main output. If the node receives no input items, the No Result output is used.

Examples

Example 1: Upsert user records

Table: users; Data Mode: Auto-Map Input Data; Column to Match On: email; Value of Column to Match On: {{ $json.email }} (auto‑mapped); Options: replace empty strings with NULL, Query Batching: Independent.