From: shaun thornburgh [mailto:[EMAIL PROTECTED] 

> 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

SELECT ... INTO OUTFILE is what you want. It's sort of covered in the
SELECT syntax documentation:

http://dev.mysql.com/doc/mysql/en/select.html

Pretty handy at times. HTH!


-- 
Mike Johnson             Smarter Living, Inc.
Web Developer            www.smartertravel.com
[EMAIL PROTECTED]   (617) 886-5539


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to