title: Mysql trigger after update New is wrong
body: <p>I created a trigger that on a table update inserts row into another table, but one of the values that I pass is getting the old value of the table I am updating.</p>
  <p>This is the trigger</p>
  <pre><code>DELIMITER $$
  CREATE TRIGGER ordersHistory
  AFTER UPDATE
     ON orders FOR EACH ROW
  BEGIN
       IF (NEW.status &lt;&gt; OLD.status) THEN
          INSERT INTO test (`test`) VALUES (NEW.ourNotes);
          INSERT INTO test (`test`) VALUES (OLD.ourNotes);
      END IF;
  END $$
  </code></pre>
  <p>This insert at the table exactly the same thing.(the old value of ourNotes)</p>