Re: Can MySQL start/fire an external process?

johnfofawn@xxxxxxxxxxx writes:

> Hi,
>
>
> Or, if that won't work. What if I have a process running and connected
> to the database (I would write the program in C or in Java). Is there
> some way to have a callback called any time a new record is added to a
> database?
>

I think I saw that version 5.0 and up have triggers, so you could set a
trigger that would write a value to a table when a record in some other table
is added, then your app could pole that record and see if it indicates that
something has happened.

Sounds like a database based semaphore, no?

Dave in Largo, FL
.

Relevant Pages

  • RE: Event when Access table is accessed through ODBC ?
    ... But the crucial thing is then is whether and how a change in the database ... Only Client-Server databases, such as SQLServer, ... Oracle, etc, support triggers. ... updated through ODBC? ...
    (microsoft.public.access.modulesdaovba)
  • Having Trouble with triggers!! ~ Please Help!
    ... master database and three satellite using triggers. ... server to be used as my remote satellite test. ... the stored procedure, right?!... ...
    (microsoft.public.sqlserver.replication)
  • RE: Event when Access table is accessed through ODBC ?
    ... But the crucial thing is then is whether and how a change in the database ... Only Client-Server databases, such as SQLServer, ... Oracle, etc, support triggers. ... updated through ODBC? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Advice sought on use of DTS [Long]
    ... it may help to know that you can disable triggers temporarily do ... You may want to set up a sql job to copy over the remote database (the ... Can you programmatically tell a DTS package which databases to update? ...
    (microsoft.public.sqlserver.dts)
  • Re: recover lost triggers
    ... had triggers) were dropped and re-created. ... Sysadmin was just backing up all of the unix file systems. ... to restore this old system over the new one. ... run alter database backup controlfile to trace on the original ...
    (comp.databases.oracle.server)