mysql查询近七天、近一年数据,没有数据补0
Mysql笔记:(mysql查询七天数据,没有数据补0)
1、sql语句:
select DATE_FORMAT(a.timeDay,'%m-%d') as time,ifnull(b.price,0) as price
from (
SELECT curdate() as timeDay
union all
SELECT date_sub(curdate(), interval 1 day) as timeDay
union all
SELECT date_sub(cu
翻译
2020-10-16 14:52:58 ·
1302 阅读 ·
0 评论