My geuss would be to write a sql script and run it from cron mysql < script.sql
> -----Original Message----- > From: Akash [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 20, 2003 1:52 PM > To: [EMAIL PROTECTED] > Subject: how to write a scheduled job for MySQL > > > Hi, > I want to periodically delete some records from a table. > Is there any > mechanism by which I can schedule a job, which will execute a > particular > query at periodic intervals ? > MySQL currently doesn't support stored procedures and > triggers... but I > guess, there must be some way around. If anyone has ever > faced this problem, > please let me know. > Thanks > Akash Agarwal > Senior Member Technical Staff, > Intersolutions Pvt Ltd, > NOIDA, INDIA > (www.lotusinterworks.com) > (www.alacre.com) > > > > --------------------------------------------------------------------- > 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
