Delete rows
WriteDelete rows matching one equality condition.
Permissions and limits
Account permissions
- DELETE on the table
A repeated request may repeat the external action. Review the previous result before retrying a write.
Data & Docs · CONNECTIONMySQL + NodeHub
Read and write rows in an external MySQL database from workflows.
Explore 6 workflow actions for MySQL, including account permissions and operation limits.
1 read action5 write actions
WORKFLOW ACTIONS
What you can configure.
Choose an action in the workflow builder, connect an account, and map its inputs. These actions are available in the catalog; your account access and a successful test determine whether they work for your setup.
Execute SQL
WriteRun one parameterized SQL statement against the selected MySQL database.
Permissions and limits
Account permissions
- Privileges required by the SQL statement
Operation limits
- SQL may change data. Use a database role with only the privileges this workflow needs.
- A lost write response is marked uncertain and not repeated.
A repeated request may repeat the external action. Review the previous result before retrying a write.
Insert or update row
WriteInsert one row, or update it when a unique key already exists.
Permissions and limits
Account permissions
- INSERT and UPDATE on the table, UNIQUE constraint on the matching key
A repeated request may repeat the external action. Review the previous result before retrying a write.
Insert row
WriteInsert one row into a MySQL table.
Permissions and limits
Account permissions
- INSERT on the table
A repeated request may repeat the external action. Review the previous result before retrying a write.
Select rows
ReadRead up to 1000 rows from a MySQL table.
Permissions and limits
Account permissions
- SELECT on the table
Pagination: limited. Check the result for additional pages; a single action may not return every record.
Update rows
WriteUpdate rows matching one equality condition.
Permissions and limits
Account permissions
- UPDATE on the table
A repeated request may repeat the external action. Review the previous result before retrying a write.
SETUP
Start with a controlled test.
01Connect the intended account
Use the account and permissions required for your process. Review the connection check before configuring a workflow action.
02Review inputs and access
Select a listed operation and map its required inputs. Use test records and add a human approval before writes that need review.
03Confirm the result
Inspect step outputs and confirm the result in MySQL. A saved workflow is not a completed provider action.
EXPLORE YOUR STACK
