That feature is only available in 3.23, while you're running
3.22. Upgrade your server and you'll get it.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -----Original Message-----
> From: lrado [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 24, 2001 13:51
> Cc: MySQL List
> Subject: sql problem - it may be a version problem ??
>
>
> hi everybody !!!
>
>
> i need to resolve the following query ( a silly one ) in a
> mysql server
> 3.22.30
> and i get the following error:
>
> mysql> select count(distinct ip_dst) from iphdr;
> ERROR 1064: You have an error in your SQL syntax near
> 'distinct ip_dst)
> from iphdr' at line 1
> mysql>
>
> i looked up in the manual ( i downloaded it from the web ) and the
> syntax is correct !!!
> ( here is the example in the manual
>
> COUNT(DISTINCT expr,[expr...])
> Returns a count of the number of different values.
>
> mysql> select COUNT(DISTINCT results) from student;
>
> )
>
> please help !!!!
>
>
> thanks in advance !!!
> laura.
>
---------------------------------------------------------------------
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
