MySQL统计近一年数据,没有则自动补0
表名:xxx时间字段:execute_time SELECT v.month,IFNULL(b.count,0) COUNT FROM ( SELECT DATE_FORMAT(CURDATE(), '%Y-%m') AS `month` UNION SELECT DATE_FORMAT((CURDATE() - INTERVAL 1 MONTH), '%Y-%m') AS `month` UNION SELECT DATE_FORMAT
转载
2020-07-31 12:06:29 ·
2003 阅读 ·
0 评论