Re: could a Trigger execute a outside command?

2005-06-27 Thread Ted Zeng
Thanks. This info. is very useful to me. I don't know if it is possible under Mac OS. But I assume it is, consider it is basically a UNIX. I just want to trigger a shell script, say, a perl script. Could a shell script be called from a C program? It looks like I will need to go through a lot

Re: could a Trigger execute a outside command?

2005-06-27 Thread Michael Kruckenberg
On Jun 27, 2005, at 1:32 PM, Ted Zeng wrote: I don't know if it is possible under Mac OS. But I assume it is, consider it is basically a UNIX. I just want to trigger a shell script, say, a perl script. Could a shell script be called from a C program? It looks like I will need to go through a

Re: could a Trigger execute a outside command?

2005-06-27 Thread Ted Zeng
When a new record is added to a specific table, I want to react to it right away, running a perl script to do something. Right now, I use a cronjob that checks the table every minuet. It is slow(it could waits up to a whole min.) and not efficient. To my understanding, I would need to put a

Re: could a Trigger execute a outside command?

2005-06-27 Thread Jeremy Cole
Hi Ted, When a new record is added to a specific table, I want to react to it right away, running a perl script to do something. Right now, I use a cronjob that checks the table every minuet. It is slow(it could waits up to a whole min.) and not efficient. To my understanding, I would need to

Re: could a Trigger execute a outside command?

2005-06-27 Thread Ted Zeng
Jeremy, Thanks. I used Perl's cron module to execute my script. So I assume only the cron mdoule is active all the time, but not my perl script. Your approach looks interesting to me. I will think about it. ted zeng On Jun 27, 2005, at 1:14 PM, Jeremy Cole wrote: Hi Ted, When a new record

Re: could a Trigger execute a outside command?

2005-06-25 Thread lparsons
Isn't this what a User Defined Function would be used for? Your trigger would call the UDF which would do a system(). Or is this not possible under Mac OS? -Lee Gleb Paharenko [EMAIL PROTECTED] I don't know any SQL statements which could launch extern commands, at least in MySQL. So in

Re: could a Trigger execute a outside command?

2005-06-25 Thread Gleb Paharenko
Hello. Yes, you're right. I've forgotten about them, sorry. [EMAIL PROTECTED] wrote: Isn't this what a User Defined Function would be used for? Your trigger would call the UDF which would do a system(). Or is this not possible under Mac OS? -Lee Gleb Paharenko [EMAIL

Re: could a Trigger execute a outside command?

2005-06-24 Thread Gleb Paharenko
Hello. I don't know any SQL statements which could launch extern commands, at least in MySQL. So in triggers it is impossible as well. Ted Zeng [EMAIL PROTECTED] wrote: Hi, I am using MySql on Mac OS X. I am wondering if I could execute a command (shell, perl) by a Trigger.

could a Trigger execute a outside command?

2005-06-23 Thread Ted Zeng
Hi, I am using MySql on Mac OS X. I am wondering if I could execute a command (shell, perl) by a Trigger. I read the manual and it seems this is impossible. ted -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL