Re: Limit und rows

["Markus Wolf" <perl_(at)_perl-archiv.de>]

Hallo,

>SELECT COUNT(*) AS total, spalte1, spalte2, ... FROM tabelle WHERE ...
>LIMIT 10;

das geht nicht, da kommt folgendes bei raus:

mysql> select count(email_link), email_link from member limit 10 ;
ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP
colum
ns is illegal if there is no GROUP BY clause

Stay charming in the year 2000 ....

/\/\arkus
    \/\/olf


---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql