[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