RE: mysql queries with numbers

[csebe]

Do it in MySQL if you can. "Use the force" ;-)
Besides MIN() and MAX() there are also statistical functions implemented as:
AVG(), STDDEV() etc.

See the manual for all functions.


Lian Sebe, M.Sc.
Freelance Analyst-Programmer
www.programEz.net

> -Original Message-
> From: Taylor Lewick [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 6:00 PM
> To: [EMAIL PROTECTED]
> Subject: mysql queries with numbers
>
>
> Question for everyone, I have a database with about 30-60 days
> worth of information.  Much of it numerical.
> Can and should I use SQL to run quereis that will return me the
> high/low and average for the time frame, as well as standard deviation,
> or should I just get all of the info into an array via perl and
> let it do the crunching?
>
> Thanks,
> Taylor
>
> 
>   Please Note
> The information in this E-mail message is legally privileged
> and confidential information intended only for the use of the
> individual(s) named above. If you, the reader of this message,
> are not the intended recipient, you are hereby notified that
> you should not further disseminate, distribute, or forward this
> E-mail message. If you have received this E-mail in error,
> please notify the sender. Thank you
> *
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql queries with numbers

[Taylor Lewick]

Question for everyone, I have a database with about 30-60 days worth of information.  
Much of it numerical.
Can and should I use SQL to run quereis that will return me the high/low and average 
for the time frame, as well as standard deviation,
or should I just get all of the info into an array via perl and let it do the 
crunching?

Thanks,
Taylor


Please Note
The information in this E-mail message is legally privileged
and confidential information intended only for the use of the
individual(s) named above. If you, the reader of this message,
are not the intended recipient, you are hereby notified that 
you should not further disseminate, distribute, or forward this
E-mail message. If you have received this E-mail in error,
please notify the sender. Thank you
*