Triggers fired by other trigger fails.... please help.
Hello,
I have a BEFORE DELETE trigger on table A, and a BEFORE DELETE trigger on table B.
The trigger on TABLE A deletes a row from table B.
If I manually delete a row from TABLE A from the MySQL profiler, then the triggers work as expected: TABLE A trigger fires, TABLE B trigger fires, row is deleted from TABLE B, row is deleted from TABLE A.
However, if I do the delete through my PHP code (using exactly the same syntax), TABLE B's trigger does not fire. The row is deleted from TABLE B, but the DELETE trigger for TABLE B never happens.
Has anyone got any ideas?
Thanks.
Subject
Views
Written By
Posted
Triggers fired by other trigger fails.... please help.
2914
June 29, 2011 09:05PM
1083
July 09, 2011 11:11PM
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.