title: Query INFORMATION_SCHEMA fields that are in db1 and IS NOT in db2
body: <p>I don't know if should I post this question here or in "Database Administrators".</p>
  
  <p>I have 2 mysql databases db1 and db2. They have some different tables, lets say, db1 has tbl_home and db2 has not. Both has tbl_city but not the same fields.</p>
  
  <p>So, I would like to know what tables and fields do db1 has that db2 has not.</p>
  
  <p>I have this query:</p>
  
  <pre><code>SELECT CONCAT (TABLE_NAME,COLUMN_NAME) FROM COLUMNS WHERE CONCAT (TABLE_NAME,COLUMN_NAME) NOT IN
  (SELECT CONCAT (TABLE_NAME,COLUMN_NAME)  FROM COLUMNS WHERE TABLE_SCHEMA ='db2')
  AND  TABLE_SCHEMA ='db1'
  </code></pre>
  
  <p>The idea is to create a concatenated stirng (tablename+fieldname) from the db1 than compare to the same list of db2. It should display every row in db1 that <strong>is not</strong> in db2.
  For some reason I don't have a error but it don't displays the correct results.
  What am I missing?</p>