Loading

2021年7月13日
Mysql分组统计最近七天数据，无则补零
摘要： SELECT DATE_FORMAT(a.timeDay, '%m-%d') AS time, IFNULL(b.success, 0) AS success, IFNULL(b.fail, 0) AS fail FROM ( SELECT curdate() AS timeDay UNION AL 阅读全文
posted @ 2021-07-13 09:47 AnNong 阅读(622) 评论(0) 推荐(0)