title: mysql: compare structure of two tables
body: <p>I have a two tables. values inside them are not identical, but most of the strcuture is the same, one of the tables has some extra fields in them.
  in a simplified form I have something like this:</p>
  
  <pre><code>|table_1|    |table_2|
  id           id
  name         name
  telephone    telephone
  email        email
               address
               language
  </code></pre>
  
  <p>I would like to copy table_2 structore over to table_1 and set address and language as NULL. To do so, I need to explicitly set them to null which is not very good, because my real table is a mess (over 30 columns). I have only 4-5 new fields though, is there a way to just compare structure between two tables and see the difference? I would just add the new fields myself then.</p>