Re: Can MySQL start/fire an external process?

johnfofawn@xxxxxxxxxxx writes:

> Thanks for your reply. I don't see how the trigger would help in this
> case. If my app still has to poll, it could poll the modified table
> just as easy as it could poll the table that is modified by a trigger.
> Right?
>
> Is there a way to make a trigger fire some sort of external event?
>
> Thanks,
> John


Look at http://dev.mysql.com/doc/mysql/en/using-triggers.html for the up to
date info on MySQL triggers. I see no way to call an external event.

Dave
.

Relevant Pages

  • Re: Can MySQL start/fire an external process?
    ... If my app still has to poll, it could poll the modified table ... just as easy as it could poll the table that is modified by a trigger. ... Prev by Date: ...
    (comp.lang.java.databases)
  • Re: Trigger functionality without trigger
    ... Without a trigger, all you can do is poll. ... write a query that tests ... This posting is provided "AS IS" with no warranties, and confers no rights. ...
    (microsoft.public.data.ado)
  • Re: Monitoring & Starting Distribution Agent thru program
    ... Kumaresh, ... you won't be able to make a trigger on this system table, ... schedule a job to run once a minute to poll the table. ...
    (microsoft.public.sqlserver.replication)
  • Re: Can MySQL start/fire an external process?
    ... If my app still has to poll, it could poll the modified table ... >>just as easy as it could poll the table that is modified by a trigger. ... I see no way to call an external event. ... Dave, ...
    (comp.lang.java.databases)
  • Re: poll() in 2.6 and beyond
    ... trigger (we should call poll() multiple times only when it returns zero). ... POLLIN bit clear in the incoming events, which your test program doesn't ... send the line "unsubscribe linux-kernel" in ...
    (Linux-Kernel)