List:General Discussion« Previous MessageNext Message »
From:Rolando Edwards Date:October 16 2008 3:14pm
Subject:RE: select ... into outfile=stdout ?
View as plain text  
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




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
select ... into outfile=stdout ?walter harms16 Oct
  • RE: select ... into outfile=stdout ?Rolando Edwards16 Oct
    • Re: select ... into outfile=stdout ?walter harms19 Oct
      • Re: select ... into outfile=stdout ?walter harms19 Oct
        • Re: select ... into outfile=stdout ?Moon's Father21 Oct