title: How do I dynamically update sql column in one table based on value in another table
body: <p>There are 2 Tables, </p>
  
  <pre><code>Reviews Table Contains:
  Overall(InnoDB):
  (value can be 1.0,1.5,2.0,2.5 .... 5.0)
  
  Stats(MyISAM):
  (contains columns R1.0,R1.5,....R5.0)
  </code></pre>
  
  <p>So when overall value is <code>5.0 I</code> want to only increment <code>R5.0</code> by 1 and when overall value is <code>1.5</code>, I want to increment only 1.5 by 1.</p>
  
  <p>I am using <code>MySQLi</code>, how do I achieve this with trigger in <code>phpmyadmin</code> ? Any help would be great.</p>