Overview
The node "RVS MySQL" allows users to interact with a MySQL database by executing SQL queries and performing common database operations such as inserting, updating, and running prepared statements. It is useful in scenarios where you want to integrate MySQL data manipulation directly into your n8n workflows without writing custom code externally.
Typical use cases include:
- Running arbitrary SQL queries to fetch or manipulate data.
- Inserting new rows into a specified table.
- Updating existing rows based on a key column.
- Executing prepared statements for parameterized queries, optionally in bulk mode.
For example, you can use this node to run a query like SELECT id, name FROM product WHERE id < 40 to retrieve product data, or insert multiple rows into a table with specified columns.
Properties
| Name | Meaning |
|---|---|
| Query | The SQL query string to execute. Required for the "Execute Query" operation. |
| Options | Modifiers for the query execution. For "Execute Query", it currently supports: |
| - Support Big Numbers: Whether to enable support for big numbers in the connection. |
Output
The node outputs an array of JSON objects representing the result of the executed SQL query or operation:
- For Execute Query, the output JSON contains the rows returned by the SQL query.
- For Insert and Update operations, the output JSON contains the result metadata from the database (e.g., affected rows).
- For Prepared Statement, the output JSON contains the results of the executed statement(s), with support for bulk execution returning combined results.
If any error occurs during execution and the node is set to continue on failure, the output will contain an object with an error property describing the issue.
The node does not output binary data.
Dependencies
- Requires a valid MySQL database connection configured via credentials that provide necessary authentication details.
- Uses an internal helper function to create and manage the MySQL connection.
- No additional external services are required beyond the MySQL server.
Troubleshooting
- Connection errors: If the node cannot connect to the MySQL database, verify that the credentials are correct and the database is accessible from the n8n environment.
- SQL syntax errors: Invalid SQL queries will cause errors. Check the query syntax carefully.
- Unsupported operations: If an unsupported operation is selected, the node throws an error indicating the operation is not supported.
- Big number handling: If working with very large numeric values, enable the "Support Big Numbers" option to avoid precision loss.
- Continue on fail: When enabled, errors do not stop workflow execution but return error messages in the output JSON.