Update

MySQL Plugin – Update Action

Summary (SEO Meta Description):
The Update Action of the MySQL Plugin allows workflows to modify existing records in a MySQL database.
It supports column mapping, conditional updates, and schema validation to ensure accurate data changes.

---

Overview

The Update Action updates one or more rows in a specified MySQL table.
You can define the columns to update, apply conditions (WHERE clauses), and use schemas for validation.

This action is essential for workflows that need to synchronize data, fix records, or apply business rules directly in the database.

Typical Use Cases:

• Update user details (e.g., email or phone number)
• Mark workflow-related records as processed or completed
• Apply corrections to transactional or medical records
• Update status fields in bulk

---

⚙️ Configuration

Field	Description	Type / Options
Label	Custom name for the action	String
Select connection	Choose or create a MySQL database connection	Dropdown
Table name	Select the target table	Dropdown
Columns	Columns to update	String (multiple allowed)
Map	Assign values to selected columns	Key-Value Mapping
Condition	WHERE clause to filter which rows get updated	String
Inputs	Manual mapping of input fields (optional)	Name + Type
Schema (Inputs)	Select or map input schema	Schema selector
Query Inputs	Define dynamic query parameters (manual optional)	Name + Type
Schema (Query)	Select or map query input schema	Schema selector

---

FAQ

Q: Can I update multiple rows at once?
A: Yes, as long as the Condition matches multiple records, they will all be updated.

Q: What happens if no condition is set?
A: Without a condition, all rows in the table may be updated. Always set a WHERE clause to avoid unintended bulk updates.

Q: Does it support dynamic mapping?
A: Yes. Columns can be mapped dynamically using workflow inputs or schemas.

---

Keywords: WeHub MySQL Plugin, MySQL Update Action, SQL Database Update, Workflow Database Integration, Update Records