What is wrong with my query?

Grafana MySQL
1

Hi,

I have a mysql table like this schema,

CREATE TABLE `analyze_result` (
`id` varchar(200) DEFAULT NULL,
`value` float DEFAULT NULL,
`start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
 CURRENT_TIMESTAMP,
 `end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
 )

.

I’ve analyzing the records from somewhere within the 4 seconds period and persist this table. So in every row in table there are 4 seconds difference between start and end.

I want to show this values in Grafana within every 4 seconds. But there is problem in my sql.

SELECT
UNIX_TIMESTAMP(start) as time_sec,
value as value,
id as metric
FROM analyze_result
WHERE $__timeFrom(start)
ORDER BY start asc;

Can you tell me what is wrong?