2011/09/03 03:40 +0800, Dennis
But it seems that there is no "select ... into LOCAL file" statement. Any
suggestion is appreciated.
Indeed: you can use only standard output.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Thanks, Tyler,Â
That's very helpful.
Dennis
--- On Sat, 9/3/11, Tyler Poland wrote:
From: Tyler Poland
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 "IN
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' \
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_lo
On 16-Mar-2003 Tim Johnson wrote:
> Hi Paul:
> * Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]:
>> At 9:14 -0900 3/16/03, Tim Johnson wrote:
>> >Hello All:
>> >I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
>> >
>> >
At 10:34 -0900 3/16/03, Tim Johnson wrote:
Hi Paul:
* Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]:
At 9:14 -0900 3/16/03, Tim Johnson wrote:
>Hello All:
>I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
>
> I believe that INTO LOCAL OUTFILE is no
Hi Paul:
* Paul DuBois <[EMAIL PROTECTED]> [030316 09:59]:
> At 9:14 -0900 3/16/03, Tim Johnson wrote:
> >Hello All:
> >I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
> >
> >I believe that INTO LOCAL OUTFILE is not implemented, but
>
At 9:14 -0900 3/16/03, Tim Johnson wrote:
Hello All:
I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
I believe that INTO LOCAL OUTFILE is not implemented, but
all the same, I would like to save a selection set into
a local output (text) file. Can someone suggest a
Hello All:
I am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
I believe that INTO LOCAL OUTFILE is not implemented, but
all the same, I would like to save a selection set into
a local output (text) file. Can someone suggest a way to
use mysqldump to do the same