@剜 获取上个月初日期
select date_sub(date_sub(date_format(now(),‘%y-%m-%d’),interval extract(
day from now())-1 day),interval 1 month) as date
获取上个月月末日期
select date_sub(date_sub(date_format(now(),‘%y-%m-%d’),interval extract(
day from now()) day),interval 0 month) as date