Delete
MySQL Plugin – Delete Action
Summary (SEO Meta Description):
The MySQL Delete Action in WeHub removes records from a specified table using workflow-driven conditions.
It ensures safe and consistent data deletion with optional schema validation.
Overview
The Delete Action of the MySQL Plugin is used to remove rows from a selected MySQL table.
You can define conditions for deletion, apply schema validation, and manage inputs dynamically within your workflow.
Typical Use Cases:
- Delete outdated or temporary records automatically
- Remove user data based on workflow logic
- Clean up invalid or duplicate entries from 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 deletion | Dropdown |
| Condition | SQL-style condition (e.g., id = 42) | String |
| Inputs | Enable Manual mode to add fields dynamically | Toggle + (Name / Type) |
| Schema | Optional schema mapping for validation | Manual / Truncate Fields |
FAQ
Q: Can I delete multiple rows at once?
A: Yes. By providing a condition (e.g., status = 'inactive'), multiple rows can be deleted in a single execution.
Q: What if I don’t provide a condition?
A: If left empty, all rows in the table may be deleted. Use carefully to avoid data loss.
Q: Does this action support schema validation?
A: Yes. Schema mapping ensures that inputs meet required data standards before deletion.
Keywords: WeHub MySQL Plugin, Delete Action, MySQL Workflow Automation, Database Cleanup