From: walter harms
Date: October 19 2008 4:15pm
Subject: Re: select ... into outfile=stdout ?
List-Archive: http://lists.mysql.com/mysql/214958
Message-Id: <48FB5D05.1000209@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

hi ronaldo,
iadmit i was mysql (the command) fixated :)

thx a lot,
 wh

Rolando Edwards schrieb:
> Try mysqldump !!!
> 
> On this web page, http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html
> 
> It says the following:
> 
> --fields-terminated-by=..., --fields-enclosed-by=..., --fields-optionally-enclosed-by=..., --fields-escaped-by=... 
> 
> These options are used with the -T option and have the same meaning as the corresponding clauses for LOAD DATA INFILE. See Section 12.2.6, "LOAD DATA INFILE Syntax".
> 
> By default, its output to stdout.
> 
> Give it a try !!!
> 
> -----Original Message-----
> From: walter harms [mailto:wharms@stripped] 
> Sent: Thursday, October 16, 2008 5:06 AM
> To: 'mysql'
> Subject: select ... into outfile=stdout ?
> 
> hi list,
> i need some options from outfile (exspecialy:FIELDS TERMINATED BY) and would like
> to send the output to stdout to further processing.
> 
> unfortunately i found no proper way to force the output to stdout. for now i use
> the redirection of the "mysql -NB" output but the interface lacks the options of
>  into outfile. (It is easy to fix using tr but not what was intended).
> 
> i tried /dev/stdout but this does not work either. any ideas ?
> 
> 
> 
> re,
>  wh
> 
> 
> 
>