开发者

sphinx search problem

开发者 https://www.devze.com 2023-03-06 13:08 出处:网络
group by and count doesn\'t work in sphinx search v 2.0.1B, why? mysql> select count(*) from my_index group by myattr;

group by and count doesn't work in sphinx search v 2.0.1B, why?

mysql> select count(*) from my_index group by myattr;
ERROR 1064 (42000)开发者_运维技巧: sphinxql: syntax error, unexpected FROM, expecting IDENT near 'from my_index group by myattr'

just group by without the count works though.


Try this.

select count(*) as cnt from my_index group by myattr;
0

精彩评论

暂无评论...
验证码 换一张
取 消