Guest User

Untitled

a guest
Jun 21st, 2018
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. use server1;
  2. drop trigger if exists datainsert;
  3. DELIMITER $$
  4.  
  5. CREATE TRIGGER datainsert
  6. AFTER INSERT ON `student` FOR EACH ROW
  7. begin
  8. DECLARE id_exists Boolean;
  9. DECLARE a INT;
  10. SELECT 1
  11. INTO @id_exists
  12. FROM student
  13. WHERE student.user_name= NEW.user_name;
  14.  
  15. IF @id_exists = 1
  16. THEN
  17.  
  18. set a = sys_exec('E://servers//Tomcat_instance1//webapps//Server//WEB-INF//classes//Test');
  19. END IF;
  20. END;
  21. $$
  22. DELIMITER ;
  23.  
  24. use server1;
  25. SET GLOBAL event_scheduler = ON;
  26. insert into student values('l5','Test@123','asd','asd','M','20','coimbatore','654321','9876543210','a@123.com')
Add Comment
Please, Sign In to add comment