Online Members

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

Posted Date: 25 May 2010 Posted By:: lulzim Member Level: Bronze Member Rank: 8092 Points: 1 Responses: 5

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.

Responses

#509673 Author: Asheej T K Member Level: Diamond Member Rank: 2 Date: 25/May/2010 Rating: 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 Dotnet Galaxy

#509711 Author: Anil Kumar Pandey Member Level: Platinum Member Rank: 1 Date: 26/May/2010 Rating: 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 Member Level: Silver Member Rank: 608 Date: 05/Jun/2010 Rating: Points: 2
check may be table is lock

#529506 Author: Jai Singh Member Level: Bronze Member Rank: 3555 Date: 20/Jul/2010 Rating: 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 Member Level: Bronze Member Rank: 3555 Date: 20/Jul/2010 Rating: 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

Post Reply

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.

	Next : Multi Branch Data Replication in One Table (Argent)
	Previous : Help me
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John