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
*

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]