MySQL Function Reference

COUNT

Returns the number of rows matching the condition. COUNT(*) counts all rows, COUNT(expr) counts only non-NULL values.

MySQL 8.1

COUNT([DISTINCT] expr | *)

expr | *

An expression or *, to count the number of rows or values

Examples

MySQL 8.1

SELECT COUNT(*)
FROM FamilyMembers;

MySQL 8.1

SELECT COUNT(DISTINCT STATUS)
FROM FamilyMembers;