title: Counting non-empty values in each column of a table
body: <p>I am looking for missing data in a data migration project, and this report will help me immensely.</p>
  
  <p>Given a MySQL table, I would like to count all the empty (NULL or '') values in each row of that table. The output would be a list of column names and a count of empty or non-empty rows for each column. This data is something I would manually compare to the source tables - manually because I expect few counts to match up <em>exactly</em> and column names are completely different between the source and imported tables.</p>
  
  <p>I have about 30 tables to check, a few with 100 columns. I have direct MySQL access from my PC, but no access to run any scripts on the server with the database.</p>
  
  <p>Example for TableA</p>
  
  <pre><code>Col1 Col2 Col3
  'XX' NULL 'XX'
  'XX' NULL ''
  'XX' 'XX' 'XX'
  'XX' ''   'XX'
  </code></pre>
  
  <p>The report I would want is (for non-empty counts with '' counted as empty):</p>
  
  <pre><code>Col1: 4
  Col2: 1
  Col3: 3
  </code></pre>