title: MySql Trigger Error: Can't update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
body: <p>I have written the code for trigger the function to update my table after inset event complete.</p>
  <p>This is my code,</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TRIGGER `first_trigger` AFTER INSERT ON `table1`
  FOR EACH
  ROW UPDATE table1
  SET test= &quot;verified&quot;
  </code></pre>
  <p>Error Message I got it,</p>
  <p><strong>Error:</strong> Can't update table 'table1' in stored function/trigger because it is
  already used by statement which invoked this stored function/trigger.</p>
  <p>How to solve this error?</p>