Hey!!! thanks thanks thanks to all of you!.
Your just wonderfull and the help you provide is priceless.
I think I will solve my problem now.
I've read about the use of variables in the manual but
It would have taken me a lot of time to figure something like this.
Thanks again and to all the res
Mauricio Pellegrini wrote:
and would like to obtain this result from a query
Col1Col2Col3
1 20 20
1 10 30
1 20 50
2 10 10
25 15
3 10 10
Column Col3 should carry forwar
--Try this, using variable @foo:
SELECT t1.col1, t2.col2, @foo := @foo + (t1.col1 * t1.col2) col3
FROM t1
On Fri, 13 Aug 2004 15:29:18 -0700, Mauricio Pellegrini
<[EMAIL PROTECTED]> wrote:
> Column Col3 should carry forward and sum values from Col2
--
MySQL General Mailing List
For list archiv
I am afraid not. A spreadsheet is the right tool for that job, not a
database. Sorry!
Of course you could always script your own solution (calculating running
totals, etc.)
Best Wishes,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
[EMAIL PROTECTED] wrote on 08/13/2004
