title: What is wrong with Mysql trigger?
body: <p>What is wrong with Mysql trigger?</p>
  
  <pre><code>CREATE TRIGGER ebdaa.active_cus AFTER UPDATE ON  ebdaa.appoints
      FOR EACH ROW
      BEGIN
          IF NEW.confirmed = 1 OR NEW.attend =1 THEN 
              update  ebdaa.appoints SET NEW.active= 1 ;
          END IF;
      END;
  </code></pre>