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 f
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 ther
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 replicat
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
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
