List:General Discussion« Previous MessageNext Message »
From:Moon's Father Date:October 21 2008 12:15am
Subject:Re: select ... into outfile=stdout ?
View as plain text  
Maybe you can use mysql -e instead.

On Mon, Oct 20, 2008 at 12:51 AM, walter harms <wharms@stripped> wrote:

> 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
> >>
> >>
> >>
> >>
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

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