title: I want to automatically update a table when my second table updated in mysql
body: <p>I have  table Table A and Table B.</p>
  
  <p>Now I want to Update my Table A automatically when my Table B is Updated or created.</p>
  
  <p>Table A value is updated by Table B value where Table A name = Table B name</p>
  
  <p>Both have 3 columns lastname, name, value.</p>
  
  <p>This is my update query but i want to update it automatically so i don't want to run it again &amp; again.</p>
  
  <pre><code>UPDATE `transformation bi`.`Table A` t1       
       JOIN `transformation bi`.`Table B` t2  
  ON t1.name = t2.name   
  SET t1.value = t2.value`   
   WHERE t1.Name = t2.Name; 
  </code></pre>
  
  <p>Thanks in advance</p>