title: Implementing Trigger on updating a column in the table in mysql
body: <p>I have table named as history and the table structure is given below</p>
  
  <pre>
  id    dubID   country     state      city          total
   1     1       India      Delhi      Delhi           5
   2     1       India      Karnatka   Banglore        100     
  </pre>
  
  <p>I have to do the updation in other table if <code>total</code> from any tuple becomes 100 (From  history table)</p>
  
  <p>Please provide your suggestion if it is possible using triggers</p>
  
  <p>Thanks in Advance!!</p>