mysql 获取当月或指定月的每天
语句 SELECT
@num:=@num+1 num,
DATE_ADD(DATE_FORMAT(DATE_ADD(curdate(),interval -day(curdate())+1 day), '%Y-%m-%d'),INTERVAL @num DAY) as days
FROM
evt_t_event a,
(select @num:=-1) num_t
WHERE
@num < (SELECT DAYOFMONTH(LAST_DAY(DATE_ADD(curdate(),interval -day(curdate())+1 day))) - 1)
