Thank you very much! I was worried because I posted the first question about a week ago twice. And guess why I am interested in 5.0? Because of the sweet triggers. I compiled the rest of the folders of 5.0 version. I like this list and MySQL.
Respectfully Yours, Iulian ----- Original Message ----- From: "Becoming Digital" <[EMAIL PROTECTED]> To: "MySQL LIST" <[EMAIL PROTECTED]> Sent: Tuesday, June 17, 2003 9:54 PM Subject: Re: I wonder why nobody answered me > > Why nobody answered me? > > I posted two questions on this list. > > 1. I have a problem with MySQL 5.0 Tree compiling. The configure after I > > launched configure.in made an error. > > Probably because there are very few people using MySQL 5.0 and we don't have an > answer. > > > > 2. How could I make accumulated sums in MySQL (described in the actual > > forwarded message) > > You asked that question five hours ago. If you want immediate support, you'll > have to pay MySQL AB for it. The downside to free stuff is that you often have > to wait a bit. You've got two replies now, though, so that should satisfy you. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > > > ----- Original Message ----- > From: "Primaria Falticeni" <[EMAIL PROTECTED]> > To: "MySQL LIST" <[EMAIL PROTECTED]> > Sent: Tuesday, 17 June, 2003 12:50 > Subject: I wonder why nobody answered me > > > Why nobody answered me? > I posted two questions on this list. > 1. I have a problem with MySQL 5.0 Tree compiling. The configure after I > launched configure.in made an error. > 2. How could I make accumulated sums in MySQL (described in the actual > forwarded message) > > > ----- Original Message ----- > From: "Primaria Falticeni" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, June 17, 2003 5:48 PM > Subject: How the Partial SUMs are made in MySQL > > > Hello, > > I need one complex query which makes partial sums on some dates. > > Let's get the structure of table rates: Day Date, Amount. > 01/05/2003 3,000 > 01/06/2003 2,000 > 01/09/2003 4,000 > > > > SELECT Day as DayF,SUM(Amount) as S_Am FROM rates GROUP BY Day > > gives the list of totals each one from a day: > DayF S_Am > 01/05/2003 3,000 > 01/06/2003 2,000 > 01/09/2003 4,000 > > > > I need the sum of the Amount from the beginning of the file until each > day...something like SUM(Amount FOR Day<DayF) on each day. > > DayF S_Am > 01/05/2003 3,000 > 01/06/2003 5,000 (I mean 3,000 on 01/05/2003 + 2,000 on 01/06/2003) > 01/09/2003 9,000 (I mean 4,000 on 01/09/2003 + 3,000 on 01/05/2003 + > 2,000 on 01/06/2003) > > > How can I do this in MySQL queries? > > Thanks in advance, > Iulian > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]