Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use server1;
- drop trigger if exists datainsert;
- DELIMITER $$
- CREATE TRIGGER datainsert
- AFTER INSERT ON `student` FOR EACH ROW
- begin
- DECLARE id_exists Boolean;
- DECLARE a INT;
- SELECT 1
- INTO @id_exists
- FROM student
- WHERE student.user_name= NEW.user_name;
- IF @id_exists = 1
- THEN
- set a = sys_exec('E://servers//Tomcat_instance1//webapps//Server//WEB-INF//classes//Test');
- END IF;
- END;
- $$
- DELIMITER ;
- use server1;
- SET GLOBAL event_scheduler = ON;
- 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