Guest User

Untitled

a guest
Dec 17th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. CREATE TRIGGER MYTRIGGER
  2. AFTER INSERT ON `tblt_timesheet`
  3.  
  4. FOR EACH ROW BEGIN
  5.  
  6. IF (NEW.timesheetid IS NOT NULL) THEN
  7. INSERT INTO `MYTABLE` VALUES (NEW.timesheetid,NEW.punchingcode, NEW.date, NEW.time, NEW.Tid);
  8. delete from `tblt_timesheet` where Tid=1;
  9.  
  10. END IF;
  11.  
  12. END
Add Comment
Please, Sign In to add comment