set @dt = now();
select extract(year_month from date_add(@dt, interval -1 month));
select extract(year_month from date_add(@dt, interval -1 year));
转载:https://blog.csdn.net/qq_35187119/article/details/83855612
set @dt = now();
select extract(year_month from date_add(@dt, interval -1 month));
select extract(year_month from date_add(@dt, interval -1 year));
转载:https://blog.csdn.net/qq_35187119/article/details/83855612