Error 1064 In Grafana For Making A Graph Using Mysql Database

I am using Grafana to make a graph of my data. I have 4 columns. The Time(using variable f), 2 sensor variables (int1 and int2) and ID. But I receive the error: Error 1064: You ha

Solution 1:

select created_at as time,id 
from table 
where created_at between FROM_UNIXTIME(1542196778) and FROM_UNIXTIME(1545893190) 
ORDER BY created_at;

this should work