不使用变量的MYSQL View

Question

我想将此查询转换为 View 。我需要消除变量的使用。 SQL代码如下:

SET @runningTotal = 0;
SELECT
    feescollected.DatePaid,  feescollected.TermPaidFor,                                                                                                                            
    feescollected.FeesPaid,
 @runningTotal := @runningTotal + feescollected.FeesPaid AS runningTotal
FROM  feescollected;

预期输出:

DatePaid    TermPaidFor     FeesPaid    runningTotal 
----------------------------------------------------    
2014-02-06  I               150000      150000
2014-03-24  I               70000       220000
2014-04-08  I               80000       300000

Answer 1

像这样吗？

SELECT
    feescollected.DatePaid,  feescollected.TermPaidFor,                                                                                                                            
    feescollected.FeesPaid,
 (feescollected.FeesPaid + 0) AS runningTotal
FROM  feescollected;