Difference between COUNT(*) and COUNT(column)?

Mid MySQL

Answer

COUNT(*) counts all rows including NULLs, while COUNT(column) counts only non-null values.

Want to bookmark, take notes, or join discussions?

Sign in to access all features and personalize your learning experience.

Sign In Create Account

Source: SugharaIQ

Ready to level up? Start Practice