MySQL: Update Data
Update existing rows in a MySQL table with WHERE conditions. ⚠️ SECURITY: Use parameterized WHERE clauses (?) to prevent SQL injection. Example: 'id = ? AND status = ?'
Plan availability #
| Feature | Free | Starter | Pro | Enterprise |
|---|---|---|---|---|
| Active workflows | 3 | 10 | 45 | Unlimited |
Allowances follow the published Chatigram pricing page. Your organization’s Billing & Plans screen confirms its subscription and current usage. Plans can change. Plan information reviewed 2026-11-10.
When to use this node #
Update existing rows in a MySQL table with WHERE conditions. ⚠️ SECURITY: Use parameterized WHERE clauses (?) to prevent SQL injection. Example: 'id = ? AND status = ?'
Add MySQL: Update Data to a workflow branch using the node picker. Configure its fields in the inspector, then connect the next step.
Before you begin #
Connect MySQL in App Connections first. Select the intended account in this node; an account connected to a different service is not interchangeable. Available actions depend on the permissions granted to that connection.
Configure the fields #
| Field | What to enter |
|---|---|
| MySQL Connection | Connected MySQL database connection |
| Table Name | Name of the table to update |
| Data to Update | Column data: column1: new_value1, column2: new_value2 |
| WHERE Clause | SQL WHERE clause: "id = ? AND status = ?" (use ? for parameters) |
| WHERE Parameters (Optional) | Parameters for WHERE clause: value1, value2 |
Use the result #
Choose the output from the variable picker in a later step. Output names below identify the values supplied by this node; the picker inserts the correct reference for your node instance.
| Output | Meaning / label |
|---|---|
result |
Result Message |
success |
Success Status |
affectedRows |
Affected Rows Count |
changedRows |
Changed Rows Count |
tableName |
Table Name |
updatedData |
Updated Data |
whereClause |
WHERE Clause Used |
error |
Error Message |
code |
Error Code |
Connect the next step #
Connect the continuation shown on the canvas. Some nodes calculate their branches from the configured options. Read each branch label in the editor and connect the paths your workflow needs.
Test it in a workflow #
- Configure this node with a small, recognizable test input or a test resource.
- Check the variables from preceding steps and the connection selected in the inspector.
- Save the workflow. For event-driven flows, generate the actual event; use Run only for a Manual workflow.
- Open Workflow Activity and check the outcome before enabling wider use.
If something goes wrong #
- Reconnect the account if authorization has expired, then verify its permissions on the specific resource.
- Check empty variables, selected resource IDs, and any fields that appeared after resource selection.
- Check the failed step in Workflow Activity before retrying. If the action may already have completed, inspect the destination first to avoid duplicates.
- Follow the troubleshooting guide for a symptom-by-symptom checklist.
Related guides #
- Work with variables
- Understand branches and error handling
- Browse all nodes
- MySQL: Connection & Automation
- MySQL: Delete Data
- MySQL: Execute Query
- MySQL: Get Automation Event
- MySQL: Get Table Schema
Catalog coverage #
This is the currently documented selection. Chatigram continues to add nodes, triggers, App Connections, and integrations. Use each page’s review date and the current application selectors to check what is available now; this catalog is not a fixed limit on future features.