RE: [PHP-WIN] a mysql query stuck for the last week ......
| From: | HKG) | Date: | Thu, 22 May 2003 06:57:07 +0000 |
| Subject: | RE: [PHP-WIN] a mysql query stuck for the last week ...... | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-20029@lists.php.net to get a copy of this message | ||
> If you analyze the different parts of this query carefully, I think
> you will realize what the problem is. The thing is: both COUNT and
> DISTINCT are SQL functions, and functions *always* (just as in PHP)
> need to have () -- parantheses.
This is not a general truth.
It is syntacticaly correct to write
SELECT distinct a,b,c,d
...