If you want to export the results of the query you may do something like the following from the mysql> prompt select field1, field2, field3, field4 into outfile '/home/rhead/result.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n' from your_table; This will produce a file in csv format, see website - http://dev.mysql.com/doc/refman/5.1/en/select.html for details. --- On Tue, 8/17/10, Roger Head <headrog@xxxxxxxxx> wrote: From: Roger Head <headrog@xxxxxxxxx> Subject: Export to CSV To: php-objects@xxxxxxxxxxxxxxx Date: Tuesday, August 17, 2010, 10:25 AM What is the best way to Export a Sql statment to a CSV or Excel file? Roger Head (709)726-4323(home) (709)690-9006(cell), (709)729-0481(work) [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
