Neal: What you are really asking is: "Does MySQL support stored procedures?"
The answer is ... at this point ... no. Implementation of stored procedures is on the 'to-do' list, but it will be awhile before you see it. There are some work-arounds ... do a search of the archive for this list, or perhaps others reading your post can offer some pointers. In my case, I run a cronjob that calls a shell script which runs an SQL query that does cleanup and backup work. Gerald Jensen ----- Original Message ----- From: "neal" <[EMAIL PROTECTED]> To: "mySQL" <[EMAIL PROTECTED]> Sent: Wednesday, December 04, 2002 12:23 PM Subject: Trigger Is there an equivilent to a trigger in mySQL? I need to build a cache mechanism for a website and I thought I'd use MySQL for persistance. The problem is that I need it to schedule a cleanup task every 24 hours - to remove old cache records. MS SQL Server provides a trigger for scheduling such tasks - I am looking for the functional analog on MySQL. Thanks. Neal Cabage --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
