SELECT DATE_FORMAT(DATE_SUB(concat(year(now()),'-12-31'), INTERVAL xc MONTH), '%Y-%m') as dates, DAY(LAST_DAY(DATE_SUB(concat(year(now()),'-12-31'), INTERVAL xc MONTH)))as dayInMouth
FROM ( SELECT @xi:=@xi-1 as xc from
(SELECT 1 UNION SELECT 2 UNION SELECT 3 ) xc1,
(SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4) xc2,
(SELECT @xi:= 12 ) xc0
) xcxc
Mysql 每月及每月天数
最新推荐文章于 2023-10-19 17:02:59 发布