Re: Can MySQL start/fire an external process?

J. David Boyd wrote:
> 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

Dave,

You can do pretty much anything you want in a UDF (make a socket call,
run some Java code using jUDF, exec() an external process, etc), which
you can call from a trigger:

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

-Mark

--
Mark Matthews
MySQL AB, Software Development Manager - Connectivity
www.mysql.com
.

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: 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. ...
    (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: 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)