mysql 取年月_MySQL 获取指定时间段的年月

# 在编写存储过程时，可能会遇到通过输入的时间，得出该时间段的年月

# 下面通过试图的方式解决该问题

# 思路：

# 创建 年 、 月 的试图

# 这里创建2010~2020 年的年份

drop view if exists v_year;

CREATE VIEW v_year AS (SELECT ‘2010‘ as yearname)

UNION ALL

(SELECT ‘2011‘)

UNION ALL

(SELECT ‘2012‘)

UNION ALL

(SELECT ‘2013‘)

UNION ALL

(SELECT ‘2014‘)

UNION ALL

(SELECT ‘2015‘)

UNION ALL

(SELECT ‘2016‘)

UNION ALL

(SELECT ‘2017‘)

UNION ALL

(SELECT ‘2018‘)

UNION ALL

(SELECT ‘2019‘)

UNION ALL

(SELECT ‘2020‘)

;

# 创建1~12 月的月份

drop view if exists v_month;

CREATE VIEW v_month AS (SELECT ‘01‘ as monthname)

UNION ALL

(SELECT ‘02‘)

UNION ALL

(SELECT ‘03‘)

UNION ALL

(SELECT ‘04‘)

UNION ALL