mysql在python中的运行,如何从mysql查询中运行python脚本？

I have a desire to call the python script from the mysql query.

like we call the procedure in mysql : call procedurename();

just like as above is there any way in mysql to call external scripts like ,

call script(somefile.py)

i wrote the above thing to explain the exactly what i want.

解决方案

This does not seem to be possible in MySQL, for security reasons. You can have a look at this related question Executing shell command from MySQL. You can however do this in other database like oracle. In Postgresql there is also support to create python stored procedures in the database. You could use this technique to have your database triggers run python code.