title: update positive to negative value in mysql
body: <p>i have payment table fields</p>
  
  <p><img src="https://i.stack.imgur.com/LWhtN.png" alt="enter image description here"></p>
  
  <p>update reason and amount &amp; total field are change negative</p>
  
  <pre><code>UPDATE payment 
  SET reason = 'refund' 
  WHERE uid =5 AND date = '2012-05-01' AND accid =2 
  </code></pre>
  
  <p>update single query is it possible?</p>