MySQL listen notify equivalent

by

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

More Related Contents:

  1. Throw an error preventing a table update in a MySQL trigger
  2. How to abort INSERT operation in MySql trigger?
  3. MySql Error: Can’t update table in stored function/trigger because it is already used by statement which invoked this stored function/trigger
  4. MySQL Trigger after update only if row has changed
  5. MySQL Event Scheduler on a specific time everyday
  6. mysql after insert trigger which updates another table’s column
  7. How to program a MySQL trigger to insert row into another table?
  8. TRIGGERs that cause INSERTs to fail? Possible?
  9. Use a trigger to stop an insert or update
  10. MySQL Fire Trigger for both Insert and Update
  11. MySQL trigger On Insert/Update events
  12. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  13. MySQL error 1436: Thread stack overrun, with simple query
  14. MySQL trigger to update a field to the value of id
  15. How can I set a maximum number of rows in MySQL table?
  16. mysql trigger stored trigger is already used by statement which invoked stored trigger
  17. My MySQL trigger doesn’t work, simple syntax, not complicated
  18. MySQL triggers cannot update rows in same table the trigger is assigned to. Suggested workaround?
  19. MySQL Trigger: Delete From Table AFTER DELETE
  20. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  21. Can I launch a trigger on select statement in mysql?
  22. Using MySQL triggers to log all table changes to a secondary table
  23. MySQL: How do I use delimiters in triggers?
  24. MySQL disable all triggers
  25. Calling an url from a trigger in mysql
  26. why this mysql event can’t get run?
  27. Truncate all tables in a MySQL database in one command?
  28. Find distance between two points using latitude and longitude in mysql
  29. Terminating idle mysql connections
  30. How to update JSON data type column in MySQL 5.7.10?

Leave a Comment