title: Update entire column with new column values based on id
body: <p>Using MySQL, my current table looks like </p>
  
  <p>Table A: </p>
  
  <pre class="lang-none prettyprint-override"><code> id_u | date       | other | calculation
  ----------------------------------
      1 | 2019-09-09 | ""    | 1
      2 | 2019-09-09 | ""    | 1
      4 | 2019-09-09 | ""    | 2
      5 | 2019-09-09 | ""    | 4
  </code></pre>
  
  <p>And I have a query (SELECT) that returns </p>
  
  <p>Query: </p>
  
  <pre class="lang-none prettyprint-override"><code> id_u | calculation
  -------------------
      2 | 12
      4 | 16
  </code></pre>
  
  <p>Wanted result after update :</p>
  
  <pre class="lang-none prettyprint-override"><code> id_u | date       | other | calculation
  ----------------------------------
      1 | 2019-09-09 | ""    | 1
      2 | 2019-09-09 | ""    | 12
      4 | 2019-09-09 | ""    | 16
      5 | 2019-09-09 | ""    | 4
  </code></pre>
  
  <hr>
  
  <p>How is it possible to update the <code>calculation</code> column for each ids ?</p>