Question: what is the difference between count() and count(*) function?
Answer: 2 Answers. COUNT(*) counts the rows in your table. COUNT(column) counts the entries in a column - ignoring null values. Of course there will be performance differences between these two, but that is to be expected if they are doing different things.