Thanks for pointing that out, I'll go with James solution.
David Godsey
David Godsey wrote:
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed
David Godsey wrote:
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed interval, I
would like the mysql daemon to push the data to my client when there is
That is a good work around, I appreciate the idea. The optimal would be a
client that listens on the mysql thread the pushes data to the database.
But if there is no way to tap into that thread, the select count(*)
would do.
There must be a way to do it though, since it is done with
I am looking for a way to write a client program that will wake up when
there is new data in the database, much like replication.
So instead of my client pulling the database on some fixed interval, I
would like the mysql daemon to push the data to my client when there is
new data. I assume this
Hi David
Sybase and MS-SQL have a built-in stored procedure called xp_cmdshell
which lets you execute shell commands from within a stored procedure
or otherwise within the database process.
MySQL doesn't (I'm fairly sure) provide anything like that (although
I think someone had written a