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 fo data stored in various tables and the sort of data is bing stored.
So 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. 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.
