Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.62 KB | None | 0 0
  1. CREATE TRIGGER leave_trigger
  2. AFTER INSERT ON leaveapplication
  3. FOR EACH ROW
  4. IF employeemaster.empcode='".$empcode."' THEN
  5. UPDATE employeemaster SET '".$leave_type=$leave_type."'-$numberofleave //I am facing problem here
  6. END IF;
  7.  
  8. UPDATE employeemaster SET '".$fieldName."=".$leave_type."'-$numberofleave
  9.  
  10. UPDATE
  11. employeemaster
  12. SET leave_type=leave_type-".$numberofleave."
  13. where empcode='".$empcode."'
  14.  
  15. CREATE TRIGGER leave_trigger
  16. AFTER INSERT ON leaveapplication
  17. FOR EACH ROW
  18. UPDATE employeemaster SET leave_type=leave_type-NEW.numberofleave where empCode=NEW.empCode
  19. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement