title: Get all column from a database where column is not Null
body: <p>I have a mysql database, and I wanted to pull all the tables and their corresponding column names. I managed to do this using the following:</p>
  
  <pre><code>SELECT `TABLE_NAME`,  `COLUMN_NAME` 
  FROM `INFORMATION_SCHEMA`.`COLUMNS` 
  WHERE `TABLE_SCHEMA`='Database';
  </code></pre>
  
  <p>But I wanted only column which are not Null for all rows, I tired the following but this did not work:</p>
  
  <pre><code>SELECT `TABLE_NAME`,  `COLUMN_NAME` 
  FROM `INFORMATION_SCHEMA`.`COLUMNS` 
  WHERE `TABLE_SCHEMA`='Database' AND `COLUMN_NAME` IS NOT NULL;
  </code></pre>
  
  <p>But the result was identical to my previous query</p>
  
  <p>Structure of the sample table from the database:</p>
  
  <pre><code>ID  Entity_ID  Balance  Security Purpose
  A1  ADF1       32131    412      NULL
  A2  JFJ4       51551    NULL     NULL
  </code></pre>