Heliont MySQLInstall

Summary

Inserts rows into a MySQL table.

Inputs

• Input Data (required) — Each item provides the values to insert. When Data Mode is set to Auto‑Map Input Data to Columns, the field names must match the column names of the target table. When set to Map Each Column Manually, values are taken from the Values to Send list.

Output shape

Two output streams: Results (default) and No Result. For an insert operation the Results stream is used.

Results output items contain an insert result object with at least the number of affected rows and, when available, the generated insert ID.

Examples

Example 1: Insert a new user record

Set Table to users, leave Data Mode on Auto‑Map Input Data to Columns, connect a Set node that provides fields name and email. The node will insert one row per input item.