On Tue, 07 Sep 2004 15:08:30 -0500, gerald_clark wrote: > > Tim McDonough wrote: > >> Is there a way to write the results of a query to an output file >> on a client computer instead of the server? My reference book >> says MySQL cannot write to a file on the client. >> >> Does MySQL not allow the LOCAL option for security reasons? You >> can run the query from a command line and redirect the output, >> it's just not nicely formatted. >> > Formatting with redirected output is no different than it is at the > mysql client command prompt, so how would a 'LOCAL' option change > anything? > > You can set the pager to a script that outputs to a file.
If there were a LOCAL option for OUTFILE I would be able to have the fields separated by commas and enclosed in quotes and make a CSV file that Excel or OpenOffice understands. MySQL on Win32, at least version 4.0.16, does not let me use the "enclosed by" and "separated by" modifiers without OUTFILE. Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
