Execute a SQL Query
Executes an SQL query on a remote MySQL database. Allows using placeholders to reference dynamic fields safely and prevent SQL injections.
MySQL Action
This integration allows you to execute SQL queries on your MySQL database automatically. You can perform operations such as SELECT, INSERT, UPDATE, or DELETE without manual intervention, optimizing your workflows and ensuring efficient data management.
When configuring this integration, it's essential to specify query parameters carefully to prevent SQL injections and maintain your database's security. Additionally, when executing queries that return results, like a SELECT, only the first result will be considered, converting each column into a tag that you can use in your automations.
Customization Options
Configurable fields you can adjust in your automation
- Query
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
- SQL Response {{sql_results}}
Let's talk
Choose day and time.
We share the screen and answer all your questions.