Maybe you can use mysql -e instead. On Mon, Oct 20, 2008 at 12:51 AM, walter harms <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED] > >> 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/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn