MySQL Forums
Forum List  »  Triggers

Re: Trigger generating Error On INSERT
Posted by: Devart Team
Date: May 20, 2011 08:12AM

It is a trigger's restriction - Restrictions on Stored Routines, Triggers, and Events. Trigger cannot modify its table.

Workaround - try to insert rows with a stored procedure.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: Reply• Quote


Subject
Views
Written By
Posted
2876
May 20, 2011 06:48AM
Re: Trigger generating Error On INSERT
1184
May 20, 2011 08:12AM


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.