0

I tried to use sys_exec but this feature doesn't work in Ubuntu. Maybe somebody knows how to run the script on event in Mysql(in windows works but not in linux)

DELIMITER $
CREATE TRIGGER On_New_Email_Insert
AFTER INSERT ON emails
FOR EACH ROW
BEGIN
DECLARE cmd CHAR(250);
DECLARE result int(10);
SET cmd = CONCAT('python3 checker.py ',NEW.customer_id);
SET result = sys_exec(cmd);
END;
$
DELIMITER ;

0 Answers0