title: ERROR 1442 Can't update table in stored function/trigger
body: <p>I am getting the error <strong>1442</strong> and it's driving me nuts! :)</p>
  
  <pre><code>ERROR 1442 Can't update table in stored function/trigger because it is already 
  used by statement which invoked this stored function/trigger
  </code></pre>
  
  <p>I am trying to insert a new row in the same table that is updated with a trigger <code>AFTER UPDATE</code>. Is this simply impossible or is there a way around it?</p>
  
  <p>thanks!</p>