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.Formatting with redirected output is no different than it is at the mysql client command prompt, so how would a
I have a work around by using a PHP script on the user's machine that does a MySQL query, formats the results, and writes them to a file but that seems a little clunky.
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.
'LOCAL' option change anything?
You can set the pager to a script that outputs to a file.
Thanks in advance,
Tim
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
