mysql查询最近30天的数据，没有数据赋值0

前言

代码如下（示例）：
可先尝试运行临时表date_table中的sql

SELECT
	date_table.dates AS datevalue,
	IFNULL( SUM( tdr.TotalNum_ ), 0 ) AS uptotal,
	IFNULL( SUM( tdr2.TotalNum_ ), 0 ) AS downtotal 
FROM
	(
	SELECT
		@s := @s + 1 AS indexs,
		DATE_FORMAT( DATE( DATE_SUB( CURRENT_DATE, INTERVAL @s DAY ) ), '%Y-%m-%d' ) AS dates 
	FROM
		mysql.help_topic,
		( SELECT @s := - 1 ) temp #不想包含当天，@s:=0
	WHERE
		@s < 30 
	ORDER BY
		dates 
	) date_table
	LEFT JOIN td_download_record tdr ON date_table.dates = tdr.CreatTime_ 
	AND tdr.Status_ = 0 
	AND tdr.CenterName_ = "重庆影像中心"
	LEFT JOIN td_download_record tdr2 ON date_table.dates = tdr2.CreatTime_ 
	AND tdr2.Status_ = 1 
	AND tdr.CenterName_ = "重庆影像中心" 
GROUP BY
	date_table.dates 
ORDER BY
	date_table.dates DESC