NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL count( * ) syntax question

Christopher R. Merlo cmerlo at ncc.edu
Mon Feb 9 18:37:10 EST 2004


Folks:
I'm running a query that has a count( column_name ) statement in it.
The query only returns a row if the count is positive.  Is there any
way to force MySQL to also generate a row if the count is zero?
MySQL's docs on the subject don't seem to say anything (probably
because this is a weird request, and I need to rethink my query).
TIA.
-c

-- 
  cmerlo at ncc.edu             http://turing.matcmp.ncc.edu/~cmerlo

In theory, there is no difference between theory and practice.  In
practice, there is.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20040209/0c0c9641/attachment.sig>


More information about the talk mailing list