MySQL: problems with Select Count(Distinct)
| From: | Tom Churm | Date: | Tue, 09 Oct 2001 10:40:28 +0000 |
| Subject: | MySQL: problems with Select Count(Distinct) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-70440@lists.php.net to get a copy of this message | ||
hi,
i've checked and the same version of MySQL is on my test-server as on my
online server (3.23.22-beta).
however, this simple query works on my test-server but NOT on my online
server:
Select COUNT(DISTINCT SemName) FROM hr_form2
i get this error message:
MySQL said: You have an error in your SQL syntax near 'DISTINCT SemName)
FROM hr_form2' at line 1
many thanks if you can offer any suggestions!
tom