MYSQL 时间轴数据 获取同一天数据的前3条

　　创建表数据

create table `praise_info` (
`id` bigint(20) not null auto_increment comment 'id',
`pic_id` varchar(64) default null comment '图片id',
`created_time` datetime default current_timestamp comment '创建时间',
primary key (`id`),
key `pic_id` (`pic_id`) using btree
) engine=innodb auto_increment=3647 default charset=utf8 comment='图片表';

 

　　添加数据省略

　　时间轴前2条数据

select * from
(
select *, @num := if(@created_time = date_format(created_time, '%y-%m-%d'), @num := @num + 1, 1) as row_num,
@created_time := date_format(created_time, '%y-%m-%d') as axistime from praise_info
order by id desc
) as temp
where row_num < 3;