From: Ed Carp
Date: March 18 1999 8:43pm
Subject: Re: Scheduled queries
List-Archive: http://lists.mysql.com/mysql/519
Message-Id: <000801be7180$08cc1e60$e26980a6@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I would like to know if is there any way of doing a scheduled query on mySQL
on Linux(say, running a summary query at 3:00 AM) . I imagine I could make a
C program that runs the query at specified time using cron, but is it
possible in any way from mySQL?
I am quite new to Linux and mySQL; I apologize if it is too obvious.


echo "select * from table..."|mysql database

mysql -e "select * from table..." database