mysql 去年同一天_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;

如您对本文有疑问或者有任何想说的，请点击进行留言回复，万千网友为您解惑！