how to run the python script from the mysql query?

Question

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.

What would be the use case for this? This is crossing domains that in my opinion shouldn't be crossed. — sean
– sean, Commented Dec 5, 2012 at 18:11
there is a event_shceduler in mysql by useing that i want run event_shcduler in mysql periodically along with calling the external scripts , Even i know cron job in linux and winwods scheduler , — neotam
– neotam, Commented Dec 5, 2012 at 18:16

Community · Accepted Answer · 2017-05-23 12:03:23Z

4

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.

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Dec 5, 2012 at 20:54

Marwan Alsabbagh

27k10 gold badges59 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to run the python script from the mysql query?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related