MySQL Forums
Forum List  »  Triggers

Triggers fired by other trigger fails.... please help.
Posted by: Victor Webster
Date: June 29, 2011 09:05PM

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.

Options: Reply• Quote


Subject
Views
Written By
Posted
Triggers fired by other trigger fails.... please help.
2914
June 29, 2011 09:05PM


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.