MySQL笔记

1.MySQL查询当月截至当天日期

SELECT
	@cdate := date_add( @cdate, INTERVAL - 1 DAY ) AS days 
FROM
	mysql.help_keyword,
	( SELECT @cdate := date_add( curdate( ), INTERVAL 1 DAY ) ) t1 
WHERE
	help_keyword_id < DAY ( curdate( ) ) 
ORDER BY
	days

 2.MySQL查询当月每一天日期

SELECT
	@cdate := date_add( @cdate, INTERVAL - 1 DAY ) AS days,
	@num := @num - 1 AS nowday 
FROM
	mysql.help_keyword,
	(
	SELECT
		@cdate := date_add( last_day( curdate( ) ), INTERVAL 1 DAY ),
		@num := ( last_day( curdate( ) ) - DATE_ADD( curdate( ), INTERVAL - DAY ( curdate( ) ) + 1 DAY ) ) + 2 
	) t1 
WHERE
	help_keyword_id < DAY ( last_day( curdate( ) ) ) 
ORDER BY
	days