title: How to update all fields from one table to another table in the same database using mySQL?
body: <p>There are 2 tables in the same database with the same structure. I want to copy all data from one table to the other table using mySQL. The source table may have the same, less or more number of rows of the destination table.</p>
  
  <p>I tried searching. I found 2 approaches:</p>
  
  <p>Approach #1</p>
  
  <pre><code>TRUNCATE destination;
  INSERT INTO destination SELECT * FROM source
  </code></pre>
  
  <p>Approach #2</p>
  
  <pre><code>DROP TABLE destination;
  CREATE TABLE destination SELECT * FROM source
  </code></pre>
  
  <p>Isn't there any other approach involving UPDATE?</p>