Insert
MySQL Plugin – Insert Action
Summary (SEO Meta Description):
The MySQL Insert Action in WeHub allows workflows to insert new rows into a MySQL table.
It supports dynamic mapping, schema validation, and custom inputs for seamless data insertion.
Overview
The Insert Action of the MySQL Plugin is used to add new records into a selected MySQL table.
You can define columns, map workflow data, and ensure schema validation for reliable inserts.
Typical Use Cases:
- Insert new user records into a MySQL database
- Store workflow results (e.g., processed files, logs, or events)
- Automatically add structured data into transactional tables
⚙️ Configuration
| Field | Description | Type / Options |
|---|---|---|
| Label | Custom name for the action | String |
| Select Connection | Choose an existing MySQL connection or create a new one | Dropdown |
| Table Name | Target table for insertions | Dropdown |
| Columns | Add column names and map workflow inputs | String (repeatable list) |
| Map | Assign workflow data to corresponding columns | Key/Value Mapping |
| Inputs | Enable Manual mode to add input fields dynamically | Toggle + (Name / Type) |
| Schema | Optional schema mapping for validation | Manual / Truncate Fields |
FAQ
Q: Can I insert multiple rows in one action?
A: The action inserts a single row per execution, but workflows can loop over data for bulk inserts.
Q: What happens if a column is missing?
A: Only specified columns will be filled; others will use their default values in MySQL.
Q: Does schema validation apply before inserting?
A: Yes. Schema mapping ensures that data is validated before insertion into the database.
Keywords: WeHub MySQL Plugin, Insert Action, MySQL Workflow Automation, Database Insert