mysql 获取当前年的每月
- 语句 (evt_t_event换成自己数据库表)
SELECT CASE WHEN length(mon) = 1 THEN concat( LEFT (CURRENT_DATE, 5), '0', mon ) ELSE concat(LEFT(CURRENT_DATE, 5), mon) END months FROM ( SELECT @m :=@m + 1 mon FROM evt_t_event, (SELECT @m := 0) a ) aa LIMIT 12