Pages

Thursday 14 May 2015

Value return Count in Mysql


Select count (*) + count (5) from table name

If 4 row present in table then print 8 because count(*) will return  4 and count (5) will also return  4.
Output - 8

Select count (*)+count (5)

If Table name is not define count(*) will return  1 and count(5) will also return  1
Output - 2