select record_time, record_content from(
select *, if(@ct = substring(tmp1.record_time,1,10), @rank:=@rank+1, @rank:= 1) rank, @ct:=substring(tmp1.record_time,1,10)
from
(select @rank=0, record_time,record_content from tableName order by record_time desc) tmp1) tmp2 where rank <=5
select *, if(@ct = substring(tmp1.record_time,1,10), @rank:=@rank+1, @rank:= 1) rank, @ct:=substring(tmp1.record_time,1,10)
from
(select @rank=0, record_time,record_content from tableName order by record_time desc) tmp1) tmp2 where rank <=5
from 一个历史表 a
where record_time>curdate()-interval 5 days
where 5>(select count(*) from 一个历史表 where date date(record_time)=date(a.record_time) and record_time>a.record_time)
这个sql可以,但是很奇怪的就是放到php代码里跑就不对了,单独在数据库里跑是对的和临时变量有关吗?