RE: Count syntax

From: Weston, Craig (OFT) <Craig.Weston(at)oft.state.ny.us>
Date: Fri Sep 28 2007 - 14:01:05 EDT

Beauford, you might find this article on cross joins interesting, it was something shown to me a few weeks ago that discusses this kind of function.

http://dev.mysql.com/tech-resources/articles/wizard/print_version.html Cheers,
craig

---

This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.

-----Original Message-----

From: Michael Dykman [mailto:mdykman@gmail.com] Sent: Friday, September 28, 2007 1:36 PM To: Beauford
Cc: mysql@lists.mysql.com
Subject: Re: Count syntax

1 means that 1 will be added to the sum if the condition tests, otherwise 0 will be added to the sum. the condition in this case is (supportertype = 'L') and will be applied to every row.

On 9/28/07, Beauford <php-list-user@netscan.ca> wrote:
> Thanks - it works, but what does the 1 and 0 do in this -
> SUM(IF(supportertype = 'L', 1, 0))
>
> > -----Original Message-----
> > From: Baron Schwartz [mailto:baron@xaprb.com]
> > Sent: September 28, 2007 1:00 PM
> > To: Beauford
> > Cc: mysql@lists.mysql.com
> > Subject: Re: Count syntax
> >
> > Beauford wrote:
> > > Hi,
> > >
> > > I have the following line of code and I keep getting wrong
> > results from it.
> > > Can someone let me know what I'm doing wrong here. I just
> > can't quite
> > > figure out the syntax that I need.
> > >
> > > select count(*) as numrows, count(supportertype) as leadcar from
> > > registrar where supportertype = 'L';
> > >
> > > What I want to do is count the total number of records and then
the
> > > total number of records that have "L" as the supportertype
> > and then display them.
> > >
> > > So I should have something like "There are 100 total records and
22
> > > with Supporter Type L".
> >
> > Try this:
> >
> > SELECT COUNT(*), SUM(IF(supportertype = 'L', 1, 0)) FROM registrar;
> >
> > Baron
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=php-list-user@netscan.ca
> >
> >
> >
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:

http://lists.mysql.com/mysql?unsub=mdykman@gmail.com
>
>

-- 
 - michael dykman
 - mdykman@gmail.com

 - All models are wrong.  Some models are useful.

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=craig.weston@oft.state.ny.us


-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com

Received on Fri Sep 28 14:02:18 2007