pr0gr4mm3r — Mon, 12 Mar 2007 17:45:30 +0000

I just looked at the mysql man page and saw this:

You can execute SQL statements in a script file (batch file) like this:
shell> mysql db_name < script.sql > output.tab

That may be what you are looking for.

pr0gr4mm3r — Mon, 12 Mar 2007 17:40:49 +0000

This may not be the most efficient answer, but it's what I do - write a PHP script that executes the query and call it by putting...

php -q path/to/file.php

...in the cron tab.