Hello.
Use 'SELECT INTO OUTFILE ...'
See:
http://dev.mysql.com/doc/mysql/en/select.html
"shaun thornburgh" <shaunthornburgh@stripped> wrote:
> Hi,
>
> The following function loads data from a file:
>
> http://dev.mysql.com/doc/mysql/en/load-data.html
>
> Is there a function like this that I can use to save the results of a query
> to a CSV file for the user of my PHP application to donwload?
>
> Thanks for your help
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com