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]
