沉睡个人博客
沉睡个人博客
博客
工具箱
留言板
沉睡个人博客
博客
工具箱
首页
数据库
查询近一个月的数据
查询近一个月的数据
1,079人已阅读
时间:2022-05-14 09:14:52
### 查询近一个月的数据,没有数据补0 SELECT tbl._date AS date_string, IFNULL( tbr.allFare, 0 ) AS num FROM ( SELECT ( @s := @s + 1 ) AS _index, STR_TO_DATE( DATE( DATE_SUB( CURRENT_DATE, INTERVAL @s DAY )), '%Y-%c-%d' ) AS _date FROM information_schema.CHARACTER_SETS,( SELECT @s :=- 1 ) AS init WHERE @s < 30 ORDER BY _date ) AS tbl LEFT JOIN ( SELECT count( IFNULL( o.id, 0 )) AS allFare, STR_TO_DATE( DATE_FORMAT( o.create_time, '%Y-%c-%d' ), '%Y-%c-%d' ) AS finish_date FROM -- t_asilver 换成要查询的表 t_asilver o GROUP BY finish_date ORDER BY finish_date ) AS tbr ON tbl._date = tbr.finish_date GROUP BY tbl._date;
上一篇:【jquery】js 获取当前年月日
下一篇:mysql查询今年的12个⽉的统计数据