MySQL Forums
Forum List  »  Triggers

Trigger to delete corresponding records
Posted by: Ken Quad
Date: August 01, 2006 08:57AM

Hi all:

I need to write a simple trigger so that whenever a record is deleted from table_a, all records with the corresponding key will be deleted from table_b. I think I know basically how to do this but I'm not sure what syntax is used to denote the primary key of the current record in the WHERE statement.

???

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger to delete corresponding records
2188
August 01, 2006 08:57AM


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.