MySQL Forums
Forum List  »  Triggers

Getting Multiple records from one Table to another after Insert
Posted by: Rajiv Terwadkar
Date: March 12, 2006 03:02PM

Dear All,
I am brand new to Triggers and Stored procedures!
Here are the details
I have 3 tables MAIN_TABLE, TABLE_1 and TABLE_2
now I want to run a trigger after insert in MAIN_TABLE.
This trigger should get one of the value of a column say MAIN_TABLE.Column_1 from MAIN_TABLE and based on that value it should pick up all the values (Select * statement) from TABLE_1 using where clause TABLE_1.Column_X = MAIN_TABLE.Column_1
and insert all the values into TABLE_2

I will appreciate if you can help me on this,
Thanks and Regards
Rajiv

Options: ReplyQuote




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.