mysql 查询1-12月
SELECT
DATE_FORMAT( CURDATE( ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 1 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 2 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 3 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 4 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 5 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 6 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 7 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 8 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 9 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 10 MONTH ), ‘%m’ ) AS month UNION
SELECT
DATE_FORMAT( ( CURDATE( ) - INTERVAL 11 MONTH ), ‘%m’ ) AS month