Use the mySQL command: 'SHOW VARIABLES'
and it will tell you what version you have (near the bottom) along with other neat stuff. Mark ------------------------------------------------------------------ [EMAIL PROTECTED] ICQ: 3094740 Safe From Bees [ www.safefrombees.com ] Quoting Andrew Dickinson <[EMAIL PROTECTED]>: > > mySQL has a slew of both aggregate and mathamatical functions: > > http://www.mysql.com/doc/en/GROUP-BY-Functions.html > > http://www.mysql.com/doc/en/Mathematical_functions.html > > Which are all useful for reporting. > > Yep, I'm familiar with these, and the aggregation needed cannot be done at > the level of single column queries like this, or even by clever inclusion > under WHERE conditions and the like. > > There are all sorts of weird conditions associated with the aggregation. > I'm using SUM and AVG for some of them, but they are mostly figures which > need to be aggregated then transformed (e.g. by operations on the data of > two or more columns or excluding some records) then sorted. Hence the > original need for Temp tables. > > > Which version of mySQL are you using? These days it matters with the new > stuff in 4.0. > > Help About says only "MySQL Control Center 0.9.3-beta" > > > ------------------------------------------------------------------ > > [EMAIL PROTECTED] > > ICQ: 3094740 > > Safe From Bees > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
