SELECT
DATE_FORMAT( CURDATE(), '%Y-%m' ) AS `year_month` UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 1 MONTH ), '%Y-%m' ) AS `year_month` UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 2 MONTH ), '%Y-%m' ) AS `year_month`
Mysql查询最近三个月数据
最新推荐文章于 2023-06-17 15:12:17 发布