List:MySQL on Win32« Previous MessageNext Message »
From:Paul DuBois Date:June 19 2001 3:41pm
Subject:Re: How can I get the "count" field
View as plain text  
At 10:04 AM -0300 6/19/01, Paulino Michelazzo wrote:
>Hi all!
>
>I need to get the "count" field in a select instruction like this:
>
>(from My-SQL help)
>
>SELECT owner, COUNT(*) FROM pet GROUP BY owner
>+--------+----------+
>| owner  | COUNT(*) |
>+--------+----------+
>| Benny  |        2 |
>| Diane  |        2 |
>| Gwen   |        3 |
>| Harold |        2 |
>+--------+----------+
>
>I use Cold Fusion with My-SQL and i can get the owner field easy, 
>but the count field IS NOT a really field

It isn't?  Why is that?

>
>Anybody can help me?
>
>Thanks a lot4
>************************************************************
>Paulino Michelazzo - IT Adviser
>http://www.michelazzo.com.br
>paulino@stripped - ICQ: 2911392
>BOX 31210 - SP/SP - CP: 01309-970 - Brazil/SA


-- 
Paul DuBois, paul@stripped
Thread
How can I get the "count" fieldPaulino Michelazzo19 Jun
  • Re: How can I get the "count" fieldJoachim Schwab19 Jun
  • Re: How can I get the "count" fieldPaul DuBois19 Jun
Re: How can I get the "count" fieldWolfgang Pichler19 Jun