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


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

Written By
trigger on year base table
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.