MySQL listen notify equivalent

mysql events triggers notify
smk picture smk · Apr 12, 2014 · Viewed 14.8k times · Source

Is there an equivalent of PostgresQL's notify and listen in MySQL? Basically, I need to listen to triggers in my Java application server.

Answer

Tomasz picture Tomasz · Oct 25, 2014

Ok, so what I found is that you can make UDF functions in mysql that can do anything but need to be written in C/C++. They can be then called from triggers on updates in database and notify your application when update happened. I saw that there are some security concerns. I did not use it myself but from what I can see it looks like something that could accomplish what you want to do and more.

http://dev.mysql.com/doc/refman/5.6/en/adding-udf.html

Related questions

MySQL Event Scheduler on a specific time everyday

Here's my query CREATE EVENT RESET ON SCHEDULE AT TIMESTAMP DO UPDATE `ndic`.`students` SET `status` = '0'; How can I update status to "0" at 1 pm every day. What can I use instead of TIMESTAMP?

Read More
How to set global event_scheduler=ON even if MySQL is restarted?

I want to set the event_scheduler global to ON even if MySQL is restarted; how can I achieve this? SET GLOBAL event_scheduler = ON;

Read More
Can I set a MySQL event schedule using phpMyAdmin?

I want to increment a field on the first minute of every day, and then once it hits a certain value, set the value to 1. I would like to do this directly in MySQL, but preferably through phpMyAdmin. I am …

Read More