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

#509673    Author: Asheej T K      25 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



Regards,
Asheej T K
Microsoft MVP[ASP.NET/IIS]
DotNetSpider MVM

#509711    Author: Anil Kumar Pandey    26 May 2010 Member Level: Diamond   Points : 2

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


Thanks & Regards
Anil Kumar Pandey
Microsoft MVP, DNS MVM

#513450    Author: Mushtaque    05 Jun 2010 Member Level: Silver   Points : 2

check may be table is lock

#529506    Author: Jai Singh  20 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

#529517    Author: Jai Singh  20 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


This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.