How to send queries to a database periodically

2005-02-24 Thread Peter PeterDresden
Hi, is there a possibillity in mysql to send periodically queries to a database, for example all 5 minutes? Or, a liitle bit off topic, is there a possibility to this via php? Or, is it normally possible to set up such a query via cron tab (unix based web servers only)? Thanx. -- MySQL

Re: How to send queries to a database periodically

2005-02-24 Thread Rhino
- Original Message - From: Peter PeterDresden [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, February 24, 2005 8:05 AM Subject: How to send queries to a database periodically Hi, is there a possibillity in mysql to send periodically queries to a database, for example

RE: How to send queries to a database periodically

2005-02-24 Thread Jay Blanchard
[snip] is there a possibillity in mysql to send periodically queries to a database, for example all 5 minutes? Or, a liitle bit off topic, is there a possibility to this via php? Or, is it normally possible to set up such a query via cron tab (unix based web servers only)? Thanx. [/snip] Yes,

Re: How to send queries to a database periodically

2005-02-24 Thread Scott Hamm
Subject: How to send queries to a database periodically Hi, is there a possibillity in mysql to send periodically queries to a database, for example all 5 minutes? Or, a liitle bit off topic, is there a possibility to this via php? Or, is it normally possible to set up such a query via

RE: How to send queries to a database periodically

2005-02-24 Thread Jay Blanchard
[snip] Where can I find cron for Windows? That will make my life a whole lot better! [/snip] It is called Task Scheduler http://www.iopus.com/guides/winscheduler.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: How to send queries to a database periodically

2005-02-24 Thread Karam Chand
SQLyog (www.webyog.com) has an option called SQLyog Notification Services. It can execute a set of queries and even send you the report over email. Using this you can schedule it to run a set of queries anytime you want. Karam --- Peter PeterDresden [EMAIL PROTECTED] wrote: Hi, is there a