编辑代码

CREATE DATABASE test;
use test;

create table a2 (
fdate datetime,
fvalue int
);

insert into a2 values
('2018/11/23', 10),
('2018/12/31',3),
('2019/2/9',53),
('2019/3/31',23),
('2019/7/8',11),
('2019/7/31',10);

create index id_fdate on a2(fdate);
/*show index from a2;*/

select date_format(fdate,'%Y') as FYEAR,
date_format(fdate,'%m') as FMONTH,
@YSUM:=(case when @Y=date_format(fdate,'%Y') then @YSUM+fvalue
else fvalue end) as YSUM,
@SUM:=@SUM+fvalue as 'SUM',
@Y:=date_format(fdate,'%Y') from a2,(select @YSUM:=0, @SUM:=0,@Y:=null)as bb