Hi,

I was trying to redirect output of a query to file attached to root
of drive c:\ . I am trying to look up type of data stored in various
tables and the sort of data is being stored.

When I use this command

echo " select * from companies order by id desc limit 10;" | mysql -u
root -p > customerapp c:/result.txt;

Then it asks me for my root password, that I feed in here.

At this point it is giving the following error.
"The process tried to write to a nonexistent pipe."

Here customerapp is the name of the database. I have treid to use /u
switch before database name (not sure about that) and --database
switch both have not worked.

Please help thanks in advance.