SQL

how to count null values in mysql

# to get the count of total null values of your sql table's column
SELECT COUNT(*) as num
FROM table
WHERE colname IS NULL;

# to get the count of total non-null values of your sql table's column
SELECT COUNT(*) as num
FROM table
WHERE colname IS NOT NULL;