;declare thisname varchar(10)
;declare done tinyint default 0;declare cur cursor for select dtime,name from `table`
;declare continue handler for sqlstate 2000 set done=1;create temporary table if not exists `tmp`(dtime datetime, name varchar(10));while done1 doif lastdtime is null thenfetch cur into lastdtime,lastname;elsefetch cur into thisdtime,thisname;if timediff(thisdtime,lastdtime)> 0:05:00 theninsert into `tmp` (dtime,name)values(lastdtime,lastname)
;set lastdtime=thisdtime;set lastname=thisname;end if;end if;end while;select * from `tmp`;End//call findtime()//
mysql 提高查询效率 mysql如何查询时间间隔大于5分钟的数据时间从现在往前推 – 数据库 – 前端 mysql django
