MySQL Forums
Forum List  »  Triggers

Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
Posted by: Christian Trummer
Date: October 20, 2006 11:03AM

when you insert a record mysql is doing some lock stuff. you can't insert/update/delete rows of the same table where you insert.. because then the trigger would called again and again.. ending up in a recursion

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger
38776
October 20, 2006 11:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.