title: SQL query to sum two or more columns and displaying them in the other column
body: <p>I'm having really hard time trying to make this work. I have this table :
  <a href="https://i.stack.imgur.com/IiIIo.png" rel="nofollow noreferrer">evid_record</a></p>
  
  <p>Its named evid_record and I want to sum columns : 'Kolokvijum teorija' + 'Kolokvijum zadaci' + 'Aktivnost' + 'Prisustvo' + 'Seminarski rad' + Domaci rad'. </p>
  
  <p>And the result should be displayed in 'Predisp. Obaveza'.</p>
  
  <p>I managed to get it partially work from phpmyadmin/mysql </p>
  
  <p>with this code:</p>
  
  <pre><code>SELECT id
       , SUM(teorija + zadaci + akt + pris + semrad + domrad) 
    FROM evid_record 
   GROUP 
      BY id
  </code></pre>
  
  <p>I get the correct results as you can see in the picture :<a href="https://i.stack.imgur.com/ciJXS.png" rel="nofollow noreferrer">my result </a> </p>
  
  <p>But I don't know how should I insert that summed data into my column 'Predisp. obaveza'. I'm not even sure if I'm on a right way. I found some similar situations people asked, tried to apply them on my project, and it didnt work..</p>