> "cumulative total index"
> ...
> > > >SELECT SUM(amount) , DATE_FORMAT( `paymentDate` , '%Y-%m' ) FROM
> > > >`payments` GROUP BY DATE_FORMAT( payments . date , '%Y-%m' )
>>>>> .....
> > > >Is there any way to get a running cumulative total directly from
> mysql?
> > > >Something like:
> > > >
> > > >amount | paymentDate
> > > >200 | 2005-01
> > > >258 | 2005-02
Will "WITH ROLLUP" do what you want ?
SELECT SUM(amount) , DATE_FORMAT( `paymentDate` , '%Y-%m' ) FROM
`payments` GROUP BY DATE_FORMAT( payments . date , '%Y-%m' ) WITH
ROLLUP
This will give you something like:
amount | paymentDate
200 | 2005-01
58 | 2005-02
258 | NULL
Will it do ?
--
Gabriel PREDA
Senior Web Developer
