"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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
