title: Trigger FOR EACH ROW
body: <p>Hi guys I am trying to make a trigger so that if the price of a beer increased more than $1 then I add the name of the bar to the RIPOFFBAR table. </p>
  
  <pre><code>CREATE TRIGGER PriceTrig
   AFTER UPDATE ON Sells
   FOR EACH ROW
  BEGIN
  IF (NEW.price &gt; OLD.price + 1.00)
  THEN
  INSERT INTO RipoffBars(bar)
   VALUES(NEW.bar);
   END IF;
   END;
  </code></pre>
  
  <p>and as you can see I used FOR EACH ROW BEGIN with IF statement
  But for some reason it is not working any help would be much appreciated </p>