MySQL Forums
Forum List  »  Triggers

Trigger from two tables
Posted by: Andre Costa
Date: November 15, 2011 11:55AM

Hi everyone!

I'm trying to do a trigger based on two tables, here's the problem: I have two tables, one is "delegacao" the other one "country", what I'm trying to do is make a trigger that before a new record is saved into the table "delegacao" it checks the table "country" and updates the value of the atributte "codigo" in the table "delegacao" with the same value of the table "country" (both tables have the atributte "codigo")


Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
Trigger from two tables
1649
November 15, 2011 11:55AM


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.