Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TRIGGER MYTRIGGER
- AFTER INSERT ON `tblt_timesheet`
- FOR EACH ROW BEGIN
- IF (NEW.timesheetid IS NOT NULL) THEN
- INSERT INTO `MYTABLE` VALUES (NEW.timesheetid,NEW.punchingcode, NEW.date, NEW.time, NEW.Tid);
- delete from `tblt_timesheet` where Tid=1;
- END IF;
- END
Add Comment
Please, Sign In to add comment