SEO

#1 (**permalink**) 02-28-2008, 10:32 AM

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.

#2 (**permalink**) 02-28-2008, 10:32 AM

On Wed, 23 Jan 2008 13:40:43 -0800 (PST), Suhasw wrote:
> 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.

Try swapping the database name and the redirect symbol.

--
30. All bumbling conjurers, clumsy squires, no-talent bards, and cowardly
thieves in the land will be preemptively put to death. My foes will surely
give up and abandon their quest if they have no source of comic relief.
--Peter Anspach's list of things to do as an Evil Overlord

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Error Piping Query in Windows