Re: LOAD DATA INFILE Opposite

[Gleb Paharenko]

Hello.



Use 'SELECT INTO OUTFILE ...'



See:

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





shaun thornburgh [EMAIL PROTECTED] 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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   ___/   www.mysql.com




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

RE: LOAD DATA INFILE Opposite

[Mike Johnson]

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 Developerwww.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]