Diffence between "select count(null)" and "select count(1)"
- by Midhat
In MySQL
Select 1 from mytable
and
select null from mytable
both return the same number of rows. While select count(1) from mytable returns the rowcount and select count(null) from mytable always returns 0. Why?