MySQL查询当月第一天到当天的日期列表

SELECT
	ADDDATE( tab2.firstDay, tab1.firstDay - 1 ) AS date 
FROM
	(
	SELECT
		1 AS firstDay UNION ALL
	SELECT
		2 UNION ALL
	SELECT
		3 UNION ALL
	SELECT
		4 UNION ALL
	SELECT
		5 UNION ALL
	SELECT
		6 UNION ALL
	SELECT
		7 UNION ALL
	SELECT
		8 UNION ALL
	SELECT
		9 UNION ALL
	SELECT
		10 UNION ALL
	SELECT
		11 UNION ALL
	SELECT
		12 UNION ALL
	SELECT
		13 UNION ALL
	SELECT
		14 UNION ALL
	SELECT
		15 UNION ALL
	SELECT
		16 UNION ALL
	SELECT
		17 UNION ALL
	SELECT
		18 UNION ALL
	SELECT
		19 UNION ALL
	SELECT
		20 UNION ALL
	SELECT
		21 UNION ALL
	SELECT
		22 UNION ALL
	SELECT
		23 UNION ALL
	SELECT
		24 UNION ALL
	SELECT
		25 UNION ALL
	SELECT
		26 UNION ALL
	SELECT
		27 UNION ALL
	SELECT
		28 UNION ALL
	SELECT
		29 UNION ALL
	SELECT
		30 UNION ALL
	SELECT
		31 
		) tab1,(
	SELECT
		CURDATE() - INTERVAL DAY (
		CURDATE()) - 1 DAY AS firstDay,
		DAY (CURDATE()) AS today 
	) tab2 
WHERE
	tab1.firstDay <= tab2.today

结果：