MySQL Expert

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

Actions6

Table → Insert

AI-generated

Summary

Insert one or more rows into a specified MySQL table using input data

Inputs

  • Table (required) — Specify the target table to insert data into, chosen from the database or set via expression.
  • Data Mode (required) — Choose how to provide the row data: either automatic mapping from input JSON fields or manual column-value specification.
  • Values to Send — Manually define columns and their values to insert when Data Mode is set to 'Define Below'.
  • Options — Configure options such as query batching mode and selecting distinct rows (rarely useful for insert but present).

Output shape

a single item containing a JSON object

Returns an object with properties 'success' (true/false), 'affectedRows' (number of rows inserted), and 'insertId' (the first autogenerated ID inserted if applicable). The output is paired with the first input item (item:0). Error details are returned if execution fails.

Examples

Example 1: Insert multiple rows using input items with automatic field-to-column mapping

Select the target table and choose 'Auto-Map Input Data' for Data Mode. Provide multiple input items where JSON keys correspond to the table columns.

Example 2: Insert a single row with manually defined column values

Select the target table and choose 'Define Below' for Data Mode. Then add the columns and values manually under 'Values to Send'.

Links

Discussion