Re: SQL to CSV
"Garry Jones" <garry.jones@morack.se> wrote in message
news:e1ej11$6gt$1@yggdrasil.glocalnet.net...
>I have a web form to collect data
>
> On submit I intend sending the data to my email address and to a mysql
> database.
>
> Whats a simple way for me to get the mysql database to email me a csv file
> from the database? On request. And every day at 08.00 say.
>
> Garry Jones
> Sweden
>
Use additional application on server, for example with cron scheduling
Simplest way is writing such app in Python or Perl + any Cron on
Linux/BSD/Unix
MySQL5.1beta has got Event Schduler but MySQL doesn't have smtpclient
functions.
Artur |