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

最新推荐文章于 2023-01-09 13:39:41 发布

狄客天行

最新推荐文章于 2023-01-09 13:39:41 发布

阅读量160

点赞数

文章标签： mysql在python中的运行

由于安全原因，在MySQL中直接调用外部脚本并不支持。你可以考虑在PostgreSQL中创建Python存储过程来运行Python代码，或者在MySQL中执行shell命令来间接执行Python脚本。这种方法增加了数据库的安全性，但需要权衡额外的系统交互复杂性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.