title: excel like calculations in a mysql table
body: <p><a href="https://i.stack.imgur.com/IoLsa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IoLsa.png" alt="enter image description here"></a></p>
  
  <p>If there are two columns id1 &amp; id2 with values shown, is it possible for mysql to join these two (ADD the two fields) &amp; into a 3rd one id. </p>
  
  <p>(So easy to do it in excel - using a formula which takes values from two columns of an excel table &amp; performs the calculation in the 3rd). Thanks  </p>