MySQL Query

[svidpet]

next question
is it possible to use a variable (eg from a sensor) in the sql statement?
something like

i’ve tried to find some solution in the thread

MySQL Command

Hi! I like storing data in my own MySQL database. But - whether it is hosted via Home Assistant’s MariaDB addon or externally - I was always baffled by the fact that there was no sleek way to insert data from Home Assistant. In past times I used a shell_command to call the MySQL Command-Line Client. But after switching to Home Assistant OS this was becoming tricky. So the idea of creating my own custom component grew in my head. I knew that the code wouldn’t be that complex. So one day I sat d…

but was unable to decode the right syntax.