title: how to merge two mysql tables with same structure
body: <p>I have 2 tables with same structure and same id (as primary key) but different data :</p>
  
  <p><img src="https://i.stack.imgur.com/pgM5Y.png" alt="two mysql tables with same structure but different data"></p>
  
  <p>Now, I need to merge them and have something like this :</p>
  
  <p><img src="https://i.stack.imgur.com/uqZqG.png" alt="merged mysql table"></p>
  
  <p>It is important to not change id of rows and not insert new records.</p>
  
  <p>How can I do that using a MySQL query ?</p>