Execute a Query
Execute an SQL query. In the event of receiving results, such as when executing a SELECT query, only the first result will be considered, with each column being converted into a tag. Be cautious when specifying parameters in the query to 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
- _status {{_status}}
Let's talk
Choose day and time.
We share the screen and answer all your questions.