Re: Affected Rows

From: Amonotod (amonotod_at_charter.net)
Date: 01/25/05

  • Next message: Thilo Planz: "Re: Please Help..Getting an error" 
    To: <dbi-users@perl.org>
Date: Mon, 24 Jan 2005 19:19:53 -0600

    > From: "Jenda Krynicky" <Jenda@Krynicky.cz>
    > Date: 2005/01/24 Mon PM 06:02:03 CST

    > COUNT(<first_column>)
    > doesn't count the rows in which the first_column is null.

    <snippage>

    > If you want the count of rows, use COUNT(*), if you want the count of
    > Foos use Count(Foo).

    Hard to argue with that, indeed it is. Myself, I never put a NULLable column in the first position of a query. You know, since that is usually a KEYed column...

    Well... Usually... For me...

    > Jenda

    Point taken,
    amonotod 

    --
    `\|||/         amonotod@    | sun|perl|windows
      (@@)         charter.net  | sysadmin|dba
  ooO_(_)_Ooo____________________________________
  _____|_____|_____|_____|_____|_____|_____|_____|
  • Next message: Thilo Planz: "Re: Please Help..Getting an error"