mysql - 选择今年的月份 MySql

Question

我想显示今年所有月份(直到今天月份)。例如，这是我想要的结果:

MONTHS
Jan
Feb
Mar

感谢您的帮助。谢谢..

Answer 1

使用以下月份(如 1-12)，您可以加入其他字段:

SELECT month, MONTHNAME(DATE_ADD(CONCAT(YEAR(NOW()),'-01-01'), INTERVAL month-1 MONTH)) as name_of_month
FROM (SELECT 1 month
             UNION ALL
             SELECT 2 month
             UNION ALL
             SELECT 3 month
             UNION ALL
             SELECT 4 month
             UNION ALL
             SELECT 5 month
             UNION ALL
             SELECT 6 month
             UNION ALL
             SELECT 7 month
             UNION ALL
             SELECT 8 month
             UNION ALL
             SELECT 9 month
             UNION ALL
             SELECT 10 month
             UNION ALL
             SELECT 11 month
             UNION ALL
             SELECT 12 month) m
 WHERE month <= MONTH(NOW())