title: MySQL said: #1064 - MySQL trigger syntax error
body: <p>This is one trigger i tried to create in phpmyadmin, mysql.</p>
  <pre><code> BEGIN
      
      IF NEW.col_paid == 9 AND  CURRENT_DATE - INTERVAL 31 DAY &gt; OLD.col_sub_date THEN
      
      UPDATE tbl_clientdata SET col_count=2;
      
      END IF;
      
      END
  </code></pre>
  <p>and getting the following error</p>
  <blockquote>
  <p>MySQL said: #1064 - You have an error in your SQL syntax; check the
  manual that corresponds to your MySQL server version for the right
  syntax to use near '== 9 AND CURRENT_DATE - INTERVAL 31 DAY &gt;
  OLD.col_sub_date THEN UPDATE tbl_c' at line 3</p>
  </blockquote>