Skip navigation links

MySQL Forums :: Triggers :: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger


Advanced Search

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
Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 55633 Georg 10/19/2006 02:47PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 28508 Christian Trummer 10/20/2006 11:03AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 21331 Georg Klaissner 10/20/2006 03:06PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 20138 mikeryksen 12/07/2006 01:38PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 21745 Jody Robbins 03/18/2008 10:13AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 15969 Peter Betzler 11/21/2006 10:43PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 16772 b G 12/24/2006 01:06PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 14880 Maarten Abbink 08/01/2007 02:02PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 11273 Roberto Fonseca 04/23/2008 08:46PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 11638 Matt Price-Hutchinson 05/15/2008 04:50AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 9789 Matt Price-Hutchinson 05/15/2008 04:51AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 11011 Saul Azcano 06/26/2008 09:32AM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 10128 Enrique Delgado 08/06/2008 04:27PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 16327 Andrej Nagy 01/05/2009 02:55PM
Re: Can't update table 'tbl' in stored function/trigger because it is already used by statement which invoked this stored function/trigger 9866 Brian Dieckman 02/25/2009 10:58AM


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.