I dont know if this can help, but if you are on unix/linux you can call
cat after the dump and easily you can get the output to the stdout
$ mysqldump....tempfile.txt... && cat tempfile.txt
On 2/20/2010 9:03 PM, Yang Zhang wrote:
> Hi, I'm interested in piping out the contents of a mysql table to
> stdout in tab-separated value format, but:
> - using 'select * into outfile' can't write to stdout.
> - mysqldump --fields-... requires --tab, which requires an output file path.
> - I also tried mkfifo /tmp/pipe and "select * into outfile
> '/tmp/pipe'", but mysql complains about the file existing already.
> Is there any other quick way to do this without having to write a
> client app? Thanks in advance.