I am using Grafana(version 5.4.0) to visualize my data on my mysql database. I want to make a graph of my data. I have four columns: id , int1(has float as type), int2(also float) and also date&time.
I would like to make a graph. On the x-axis the time and on the y-axis the value of int1. My tables name is data5.
This is my querry code:
SELECT f AS "time", int1 FROM data5 WHERE $__timeFilter(f) ORDER BY f
this is the error:
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘int1 FROM data5 WHERE f BETWEEN FROM_UNIXTIME(1563793531) AND FROM_UNIXTIME(15’ at line 3
I would be thankful for any kind of help.
this is my dashboard:
and this is my database:
I would be thankful for any help.