Thanks, Tyler, That's very helpful. Dennis --- On Sat, 9/3/11, Tyler Poland <tpol...@engineyard.com> wrote:
From: Tyler Poland <tpol...@engineyard.com> Subject: Re: select ... into local outfile ... ??? To: mysql@lists.mysql.com Date: Saturday, September 3, 2011, 3:45 AM Dennis, The following closely simulates the default "INTO OUTFILE", you'll have to modify it slightly for your purposes: mysql --delimiter=comma -N < select_statement.sql \  | sed 's/\"/\\\"/g' \  | sed 's/\t/\",\"/g' \  | sed 's/$/\"/g' \  | sed 's/^/\"/g' \  | sed 's/\"NULL\"/\\N/g' \  | sed 's/\\t/\t/g' ' > output.txt Tyler * *On 9/2/11 3:40 PM, Dennis wrote: > hi, there, > the following is my sql statement: > SELECT   HIGH_PRIORITY   SQL_BIG_RESULT   SQL_NO_CACHE >  tb.url_sign, m_url,  m_title,   m_weight  INTO >OUTFILE   '/tmp/a.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '\"'   LINES >TERMINATED BY '\n' STARTING BY '=' > FROM d_local.ta, d_news.tbWHERE ta.url_sign = tb.url_sign > > Before, the server and the client were on the same machine; now, I need to > generate the output file on client (which is on a different machine from the > server). But it seams that there is no "select ... into LOCAL file" > statement.Any suggestion is appreciated. > Dennis >