title: Sum up columns using group by and store as a new column (permanently) in MySQL
body: <p>I have 50 columns in the MySQL table. I want to sum all these columns and make a new column into the same table (sum50). 
  This should be stored permanently into the MySQL table whenever I update or insert new data. 
  I know how to sum up while performing the query but it does not store into the table permanently.</p>
  
  <pre><code>CREATE TRIGGER `name` 
  AFTER INSERT ON `table` 
  FOR EACH ROW  
  UPDATE `table` SET `table`.`coulms` =  `table`.`col1`+....      `table`.`col50`+    
  </code></pre>
  
  <p>I am trying the above trigger, but not working. 
  Should I have a blank column inserted into the table and perform trigger? Which trigger would be correct?</p>