View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 09:46 AM
strawberry
 
Posts: n/a
Default Re: how many of a kind

On May 9, 6:42 pm, Stefano Perna <ajajaja...@tin.it> wrote:
> strawberry wrote:
>
> > select count(product_name) from table group by cat_id

>
> very good, thanks!
>
> Is the result always ordered? That is, do I receive data as they were
> ordered by cat_id?


Like me, Mysql is inherently lazy. You can pretty much assume that it
doesn't do anything unless specifically asked - but sometimes you get
lucky.

Reply With Quote