title: MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
body: <p>MySQL doesn't currently support updating rows in the same table the trigger is assigned to since the call could become recursive. Does anyone have suggestions on a good workaround/alternative? Right now my plan is to call a stored procedure that performs the logic I really wanted in a trigger, but I'd love to hear how others have gotten around this limitation.</p>
  
  <p>Edit: A little more background as requested. I have a table that stores product attribute assignments. When a new parent product record is inserted, I'd like the trigger to perform a corresponding insert in the same table for each child record. This denormalization is necessary for performance. MySQL doesn't support this and throws: </p>
  
  <p><code>Can't update table 'mytable' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.</code>  A long discussion on the issue on <a href="http://forums.mysql.com/read.php?99,122354,122354" rel="noreferrer">the MySQL forums</a> basically lead to: Use a stored proc, which is what I went with for now.</p>
  
  <p>Thanks in advance!</p>