List:General Discussion« Previous MessageNext Message »
From:walter harms Date:October 19 2008 4:51pm
Subject:Re: select ... into outfile=stdout ?
View as plain text  
hi ronaldo i tried and failed.
it seems that mysql has no option to specify a select statement.
did i mis something ?

re,
 wh


walter harms schrieb:
> 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
>>
>>
>>
>>
> 
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