MySQL Forums
Forum List  »  Triggers

Execute 'After Insert' trigger only after insert is commited
Posted by: Ramakrishna M
Date: June 13, 2011 12:51AM

Hi All,

I am using MySql 5.1.39 and I got struck with some problem related to triggers.

I have written one trigger which is supposed to be invoked once data is inserted into the Table. I want this trigger to be invoked only after the data inserted into the table is commited instead of being invoked immediately after insert. I have disabled the autocommit for the table.

Please let me know if this is possible. Any kind of help is highly appreciated.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Execute 'After Insert' trigger only after insert is commited
2749
June 13, 2011 12:51AM


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.