mysql 查询数据 逐行累加

SET @sum := 0;
SELECT *, (@sum := @sum + flow) AS cumulative_sum
FROM wrs_brwater_avg_gq WHERE  mea_date > '2023-04-15'
ORDER BY mea_date; 

mybatis 使用变量查询 链接url需要加上 &allowMultiQueries=true