Thread: SQL to CSV
View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 07:35 AM
Bill Karwin
 
Posts: n/a
Default Re: SQL to CSV

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.
Reply With Quote