Mysql trigger that can notify the c code about change in table

Question

I have been searching for a way that can help me notify the C code about successful INSERT operation fired over a Mysql table.

So the insert query is already there in other component code, now in an independent component I want to get notified when Insert on a particular table takes place so that I could fire select on the table. Currently I fire select query on particular interval, need to avoid that and instead do it after an insert query.

Does this answer your question? Using MySQL C API - check success of inserting rows using prepared statements — P.Salmon
– P.Salmon, Commented May 5, 2020 at 12:05
@P.Salmon No sir, Actually I already have insert query in other component code. Now I just want that to be notified in some other code when insert is fired on a particular table. — Disha Shetty
– Disha Shetty, Commented May 5, 2020 at 13:02
MySQL does not inform a client about modifications. It just responses to requests from clients (e.g. your c app). Instead of relying on an external server to do the talking, you have to modify your components to talk to each other. — Solarflare
– Solarflare, Commented May 5, 2020 at 13:51

Rick James · Accepted Answer · 2020-05-17 18:27:15Z

0

Don't give users INSERT privilege to tables. Instead, make the go through an API -- either a Stored Procedure or a client API. There do any monitoring/etc you need.

Note that MySQL cannot (for security reasons) launch anything outside itself -- no email, callbacks, etc. There is an exception: UDFs (User Defined Functions).

answered May 17, 2020 at 18:27

Rick James

144k15 gold badges144 silver badges255 bronze badges

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

Collectives™ on Stack Overflow

Mysql trigger that can notify the c code about change in table

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