mysql信号灯数据查询分析

set @begingreen='12:06:22';
set @beginflash='12:06:40';
set @endgreen='12:06:55';
select TIME_TO_SEC(@begingreen);
select TIME_TO_SEC(@endgreen);
select * from MultiDataViewerInfo where TIME_TO_SEC(Time)>TIME_TO_SEC(@begingreen) and TIME_TO_SEC(Time)<TIME_TO_SEC(@endgreen) GROUP BY Time ORDER BY Time ASC;
-- 绿灯
select TIME_TO_SEC(@begingreen);
select TIME_TO_SEC(@beginflash);
select * from MultiDataViewerInfo where TIME_TO_SEC(Time)>TIME_TO_SEC(@begingreen) and TIME_TO_SEC(Time)<TIME_TO_SEC(@beginflash) GROUP BY Time ORDER BY Time ASC;
-- 绿闪
select TIME_TO_SEC(@beginflash);
select TIME_TO_SEC(@endgreen);
select * from MultiDataViewerInfo where TIME_TO_SEC(Time)>TIME_TO_SEC(@beginflash) and TIME_TO_SEC(Time)<TIME_TO_SEC(@endgreen) GROUP BY Time ORDER BY Time ASC;