calling perl script from mysql trigger
- by Bahareh
I want to call a perl script inside a mysql after insert trigger.
but my trigger does not work.I find this solution from google.
here is my code:
DROP TRIGGER IF EXISTS 'tr1'//
CREATE TRIGGER 'tr1' AFTER INSERT ON 'username'
FOR EACH ROW begin
SET @result=sys_exec(CONCAT('/usr/bin/perl /etc/p1.pl'));
end
//
and my p1.pl code:
#!/usr/bin/perl
open(MYFILE,'>>/etc/data.txt');
print MYFILE "BOB\n";
close MYFILE;
thanks.
