DEV Community

Roopak A N
Roopak A N

Posted on

Difference between `count(*)` and `count(column_name)`

#mysql #database

I found this interesting Medium article from Joshua Otwell about the difference between count(*) and count(column_name).

Good 2 minutes read - https://medium.com/an-idea/mysql-count-and-count-column-or-expression-differences-e480b0db5f43

Top comments (0)

Read next

jagroop2001 profile image

SQL Cheatsheet: A Handy Reference for SQL Commands with Examples

Jagroop Singh -

alexmercedcoder profile image

A Guide to dbt Macros - Purpose, Benefits, and Usage

Alex Merced -

truongpx396 profile image

🧪 GOLANG INTEGRATION TEST WITH GIN, GORM, TESTIFY, MYSQL

Truong Phung -

franckpachot profile image

You Probably Don't Need Serializable Isolation

Franck Pachot -