title: MySQL trigger not updating table
body: <p>This code is very similar to my problem. I'm not sure why Table A is not updated at all. I <code>SELECT * FROM A</code> at the end and A remains empty. I've been at this for hours and I can't figure out why my trigger is not working. Thanks</p>
  
  <pre><code>CREATE TABLE A
  (
  aVariable int
  );
  
  CREATE TABLE B
  (
  bVariable int
  );
  
  delimiter //
  
  CREATE TRIGGER AB
  AFTER INSERT ON B
  FOR EACH ROW
  BEGIN
      IF (NEW.bVariable &lt; 10) THEN //I also tried bVariable &lt; 10
         INSERT INTO A VALUES (11)
      END IF;
  END;
  
  delimiter ;
  
  INSERT INTO B VALUES (1);
  
  SELECT * //A is still empty
  FROM A;
  
  SELECT *
  FROM B;
  </code></pre>