mysqltriggersnewrow

Check MySQL new record without Pooling

I am searching about a method to check for new records (in MySQL table) without pooling each X seconds or minutes.

I have found that MySQL triggers could be used but it can't call an external program or PHP file?

Solution

  • You can call external program in trigger through

    sys_exec()

    See:

    http://crazytechthoughts.blogspot.jp/2011/12/call-external-program-from-mysql.html