Execute trigger after insert

Asked Jul 25 '19 at 16:35

Active Jul 25 '19 at 16:35

Viewed 129 times

I would like to execute a script (over linux) after a insert appears on a table.

What's the correct form to do it? I have this but can't run. If I execute from mysql shell /scripts/script1.sh it's run correctly

DELIMITER $$
CREATE TRIGGER telegram
AFTER INSERT ON `users`
FOR EACH ROW
BEGIN
\! /scripts/script1.sh
END $$
DELIMITER;

thanks in advance

asked Jul 25 '19 at 16:35

Guif If

1

https://stackoverflow.com/a/52173646 – IVO GELOV Jul 25 '19 at 16:46
1

Check this: https://stackoverflow.com/questions/41951746/execute-shell-commands-from-mysql-stored-procedure – Tsvetelina Mariyanova Jul 25 '19 at 16:46
is it necesary to use lib_mysqludf_sys instead "\!" ? – Guif If Jul 25 '19 at 17:02

0 Answers0