I don't think you can tell mysql to run any commands whena records is inserted.
But what I do to achievge asimilar effect is this:
In the table I have a INT(1) field, say, Proc.
INSERT INTO Proc=1 ...
Then I cron a script to do this every hour or whatever:
SELECT ... WHERE Proc=1..
Foreach
From: "Nick Diel" <[EMAIL PROTECTED]>
> I am working on a project where machines will use a perl script to
> write to a table in a MySQL database. I want a perl script to run
> everytime there is a new entry, but I don't know how to trigger the
> perl script when there is a new entry (the perl to
I am working on a project where machines will use a perl script to write to
a table in a MySQL database. I want a perl script to run everytime there is
a new entry, but I don't know how to trigger the perl script when there is a
new entry (the perl to be triggered will be sitting on the same box a
