sys_exec () can run a python program

[Luca Lucchesi]

hello,

for test reasons, I have a python program who writes to a file. txt date and the current time.


select sys_exec('python /var/test/script/aa.py');

I gave chown mysql:mysql aa.py and chmod 777 aa.py

result is:
+-------------------------------------------+
| sys_exec('python /var/test/script/aa.py') |
+-------------------------------------------+
| 0 |
+-------------------------------------------+
1 row in set (0.23 sec)



but nothing appears in the text file

will you give me some suggestions please?

thanks