MySQL counts all NULL columns

Question

I need to count and return the number of NULL columns in my MySQL query.

SELECT * from posttracks WHERE trackid=100000; 

How would I COUNT all NULL columns?

Edit: to be clear, I don't need the number of rows with null values, I need the number of columns in a row with NULL values.

Answer 1

 SELECT count(*) from posttracks WHERE Col1 is NULL 

Answer 2

If I understand your question correctly:

 SELECT ISNULL(col1) + ISNULL(col2) + ... + ISNULL(col16) AS cnt FROM yourTable WHERE trackid=100000 

Answer 3

I assume that you are trying to find all rows that have at least one iS NULL column.

Let's say you have three columns - col1, col2, col3 in the table - table1. then you can write a query like

SELECT COUNT (*) FROM table1 WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL.

If you have more columns, join them using OR

Answer 4

 SELECT count(*) as amount FROM posttracks WHERE trackid IS NULL GROUP BY trackid; 

Answer 5

select count(*) from posttrack where trackid is null;

Edit: duplicate previous answer