mysql查询七天数据,没有数据补0
mysql查询七天数据,没有数据补0select DATE_FORMAT(a.timeDay,'%m-%d') as time,ifnull(b.price,0) as pricefrom ( SELECT curdate() as timeDay union all SELECT date_sub(curdate(), interval 1 day) as timeDay union all SELECT date_sub(curdate(), interva.
转载
2021-06-25 10:58:01 ·
923 阅读 ·
0 评论