You must Sign In to post a response.

Can't update table 'tbl' in stored function/trigger because it is already used by statemen

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

In every insert statement i use will show this error.
Do u have any idea what kind of error is this.
Im using triggers in mysql.


Comments

Author: Asheej T K25 May 2010 Member Level: Gold   Points : 2

Same issue has been addressed in below links,

http://forums.mysql.com/read.php?99,122354,240978#msg-240978

http://forums.mysql.com/read.php?99,122354,122505#msg-122505

Author: Anil Kumar Pandey26 May 2010 Member Level: Diamond   Points : 2

may be the table is already in used.. better to use transaction to avoid such things.

Author: Mushtaque05 Jun 2010 Member Level: Silver   Points : 2

check may be table is lock

Author: Jai Singh20 Jul 2010 Member Level: Bronze   Points : 2

In MySql there is no provision to write trigger to update
multiple row. if u want to update multiple row at a time through
trigger then write sp and call it from trigger;
jai singh

Author: Jai Singh20 Jul 2010 Member Level: Bronze   Points : 2

In MySql there is no provision to write trigger to update
multiple row. if u want to update multiple row at a time through
trigger then write sp and call it from trigger;if ur SP will not
work for this then call ur stored procedure at specific time interval.
jai singh


Sign In to post your comments