MySQL Expert

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

Actions6

Table → Update

AI-generated

Summary

Update rows in a specified MySQL table using provided data, matching rows based on one or more specified columns to identify which records to update.

Inputs

  • Table (required) — Select the MySQL table to update rows in.
  • Data Mode (required) — Choose how to specify the data to update: automatically map input fields or manually define column-value pairs.
  • Values to Send — When manually defining data, specify the columns and their new values to update.
  • Columns to Match On (required) — Select one or more columns whose values will be used to match rows to update (acts as the WHERE clause).
  • Options — Additional options such as query batching method and whether to select distinct rows (though distinct mainly applies in selects).

Output shape

a single record indicating success with affected and changed rows counts

Counts of affectedRows and changedRows are returned in the output JSON. If no columns to match on are specified, an error is thrown. Data must include all matching columns for the update operation to succeed.

Examples

Example 1: Auto-Map Input Data mode: the node updates rows where the specified match columns equal input data values, updating other columns from input data fields (excluding match columns).

Set 'Table' to target table, select 'Auto-Map Input Data' for 'Data Mode', specify the 'Columns to Match On' to identify rows, and supply input data fields with values for updating.

Example 2: Define Below mode: manually specify the columns and values to update and the columns to use for matching rows.

Set 'Table', select 'Define Below' for 'Data Mode', add one or more 'Values to Send' columns with their values, and set 'Columns to Match On' to identify rows to update.

Links

Discussion