MySQL Expert

Query MySQL with easy field selection - only get the data you need

Actions6

Table → Insert or Update

AI-generated

Summary

Insert a new row or update an existing row in a specified MySQL table using an upsert operation, matching on one or more specified columns.

Inputs

  • Table (required) — Select the target table to insert or update rows in.
  • Data Mode (required) — Choose between auto-mapping input data fields to table columns or manually defining the column-value pairs below.
  • Values to Send — Manually specify column-value mappings to insert or update; used only if 'Data Mode' is set to 'Define Below'.
  • Columns to Match On (required) — Specify one or more columns used to determine whether to update an existing row or insert a new row (composite key match).
  • Options — Additional options for query execution such as query batching method.

Output shape

a single record

Returns a single JSON object indicating success status, number of affected rows, and insert ID upon completion of the upsert operation. This output is paired with the first input item (index 0). Errors throw node exceptions unless 'Continue On Fail' is enabled.

Links

Discussion