MySQL trigger with python

Question

I have a python script( script 1) that adds elements in a table in MySQL database using mysql.connector module, and I have another python script( script 2) that reads data from that table, I want to put a trigger on that table and each time a new element is added script 2 notice the new added element and display a message on the console.

I'm looking for something like the nodeJS npm package "mysql-events" that watches a MySQL database and runs callbacks on matched functions

Ajeet Mishra · Accepted Answer · 2020-09-15 15:13:55Z

0

I know this is an old question. But I was searching the same today for my work and came across this link - mysql - Run python script on Database event. Look at the answer which has been submitted by the person asking question. It might help you/someone.

answered Sep 15, 2020 at 15:13

Ajeet Mishra

3821 gold badge2 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

MySQL trigger with python

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