Re: Scheduled queries

[Ed Carp]

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