On Fri, Feb 23, 2001 at 08:13:20PM +0900, Sam Joseph wrote:
>
> however on the MySQL versions I currently have access to (3.22.32 &
> 3.22.34) I get this:
>
> mysql> select COUNT(DISTINCT SOME_COLUMN) from SOME_TABLE;
> ERROR 1064: You have an error in your SQL syntax near 'DISTINCT
> SOME_COLUMN) from SOME_TABLE' at line 1
>
> I am assuming that either this function is not available or that it is a
>
> bug that has been fixed in a later release (or is on a todo list
> somewhere).
>
It is a new feature of 3.23.xx. It wasn't supported in 3.22.x and not
described in the 3.22.x manual either.
You'll need to upgrade to 3.23.x if you really want it. You can try
to use a SELECT COUNT(*) FROM SOME_TABLE GROUP BY SOME_COLUMN.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
