title: Change column value based on another column using MYSQL Triggers
body: <p>i want a trigger to be able to change the value of status=1 when balance is 0 and status=0 when the value of balance is not equal to 0 after update only ..</p>
  
  <p><a href="https://i.stack.imgur.com/Kej8G.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Kej8G.jpg" alt="Mysql Table"></a></p>