Database
The SQL POST query (insert/update) was executed with id Query ID.
MySQL
Access your MySQL database from Homey
Add a database of your MySQL compatible server as device to homey.
Use a flow card in the THEN part to execute a SQL query. Push sensor data to a database table if you want to log it.
Execute SELECT statements in the flow card to read data from your database.
React on the executed query in with a flow trigger and push the value to a virtual sensor.
Obsługiwane urządzenia
Karty Flow
Kliknij na urządzenie powyżej, aby wyświetlić tylko powiązane karty Flow.
Kiedy...
Triggers when the SQL POST query (insert/update) was executed and delivers the result as token. The execution can be filtered by Query ID.
Database
The SQL query was executed with id Query ID.
Triggers when the SQL query was executed and delivers the result as token. The execution can be filtered by Query ID.
Oraz...
Database
The result (as number) of SQL query SQL query with ID ID is ...
The result of the SQL query. Select a single numeric field to compare.
Database
The result (as number) of SQL query SQL query with ID ID is greater than ...
The result of the SQL query. Select a single numeric field to compare.
Database
The result (as text) of SQL query SQL query with ID ID is ...
The result of the SQL query. Select a single field to compare.
Database
The SQL query SQL query with ID ID was processed successfully
The flow continues when the SQL query is successfully executed.
Wtedy...
Database
Executes the SQL query with ID ID: SQL query.
Use this action for SQL querys. An ID must be specified to evaluate the result. In the flow event, the response can be read via the Query ID. Use '[date-1d]', '[date-1m]' oder '[date-1y]' for calculation of a date based on the current date using a positive/negative difference in days, moths or years.
Advanced
Database
Executes the SQL query with ID ID: SQL query.
Use this action for SQL querys. An ID must be specified to evaluate the result. In the flow event, the response can be read via the Query ID. Use '[date-1d]', '[date-1m]' oder '[date-1y]' for calculation of a date based on the current date using a positive/negative difference in days, moths or years.
Pomoc
Masz problem z tą aplikacją? Skontaktuj się z twórcami aplikacji za pomocą forum Homey Community.
Nowości
Wersja 1.0.4 — Workaround for wrong time conversion (UTC->local) in date variable '[date-1d]'.
MySQL
MySQL nie jest kompatybilna z wybranym Homey.
MySQL zostanie wkrótce zainstalowana na Homey.
Lista zmian
Wyślemy podziękowanie do Ronny Winkler!
Poinformujemy Ronny Winkler, że uwielbiasz tę aplikację. Być może rozważ wsparcie dla Ronny Winkler poprzez dokonanie darowizny?
Wspomóż Ronny Winkler darowizną
Osoba, która stworzyła aplikację MySQL, przyjmuje darowizny.
Podziękuj za apkę i prześlij środki!
