title: Updating of NEW row is not allowed in after trigger
body: <p>Why do I get an error using this <em>trigger</em>?</p>
  
  <pre><code>CREATE TRIGGER save_Assignee AFTER INSERT ON changeitem
  FOR EACH ROW 
  BEGIN 
      SET new.assignee = (
          SELECT assignee
          FROM jiraissue INNER JOIN changegroup ON jiraissue.ID = changegroup.issueid
      )
  END
  </code></pre>
  
  <p><br>
  Error message:</p>
  
  <blockquote>
    <p>#1362 - Updating of NEW row is not allowed in after trigger</p>
  </blockquote>