Artur Baæ wrote:
> MySQL5.1beta has got Event Schduler but MySQL doesn't have smtpclient
> functions.
Heh! Zawinski's law has not (yet) affected MySQL!
http://en.wikipedia.org/wiki/Zawinski%27s_Law
I agree -- write a simple script on the server, run by cron, to dump
data into a CSV file and then email that file. One can run a SQL query
"SELECT ... INTO OUTFILE" to do this.
See paragraph on SELECT ... INTO OUTFILE in the following page:
http://dev.mysql.com/doc/refman/5.0/en/select.html
Regards,
Bill K.