The Arcive of vBulletin Modifications Site.

filburt1 · #1 11-02-2002, 06:36 PM

LOL, I came across this while researching the use of COUNT(*):

Code:

Number of animals per sex: 

mysql> SELECT sex, COUNT(*) FROM pet GROUP BY sex;
+------+----------+
| sex  | COUNT(*) |
+------+----------+
| NULL |        1 |
| f    |        4 |
| m    |        4 |
+------+----------+

Null? Hopefully that means not specified and not "neither"

assassingod · #2 11-02-2002, 06:42 PM

Ha:ninja:
You forgot the possibility that it could mean both

Dean C · #3 11-02-2002, 08:21 PM

lmfao