MySQL Forums
Forum List  »  Triggers

trigger on year base table
Posted by: Rommel Masallo
Date: July 08, 2012 04:09AM

hello guys,

can you guys help with this one, I have a year base table how can i make a trigger on this

ie.

insert must be done on masterfile table - employeeno

i want to make a trigger for the following table sss2012, pagi2012, on year 2013 i will add new table which will be sss2013, pagi2013 on 2014 this will be new again and so on.

can you give me a sample trigger for this. thanks and more power.

Options: ReplyQuote


Subject
Views
Written By
Posted
trigger on year base table
1785
July 08, 2012 04:09AM


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.