Check MySQL new record without Pooling

Question

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?

If there is no specific checking you can write an stored procedure, which be executed by trigger: http://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html — vanadium23, Apr 29 '15 at 15:19
Thank you VANADIUM23, have you another method without using triggers ? — PHP5, Apr 29 '15 at 15:25

score 1 · Accepted Answer · answered Apr 30 '15 at 07:47

1

You can call external program in trigger through

sys_exec()

See:

answered Apr 30 '15 at 07:47

turutosiya

1 Answers1