MySQL Forums
Forum List  »  Triggers

trigger new row join other table
Posted by: Jingtan Li
Date: January 08, 2014 03:30AM

table_a
country_id
country_GDP

table_b
province_id
province_GDP


table_c
country_id
province_id

I want make a trigger in table_b,if province_GDP changed, country_GDP in table_a will change.

the problem is :

I don't know how to join the table_c to the new row.

Options: ReplyQuote


Subject
Views
Written By
Posted
trigger new row join other table
2160
January 08, 2014 03:30AM
1202
January 08, 2014 03:50PM


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.