Totals

[Craig Gardner]

I need to get totals for the data in my database.  I stumbled upon the 
"WITH ROLLUP" modifier 
(http://www.mysql.com/doc/en/GROUP-BY-Modifiers.html) and it appears to 
be exactly what I'm looking for, except for the fact that when I try to 
use it I get the following message:

	This version of MySQL doesn't yet support 'ROLLUP'

The version of mySQL I have installed on this machine is 
"4.0.18-standard".  Is there something I need to install/configure to 
get this modifier to work properly, or is there another way to get the 
totals I want.

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