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.