List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 3 2001 1:12am
Subject:Re: windoze and batch files
View as plain text  
At 10:23 AM +1000 5/3/01, Bordeaux Stan wrote:
>Hi all,
>unfortunately, I am forced to do some background mysql development work on a
>windoze box, which for reasons I wont go into here requires that I use the
>mysql console client.  As many would know this does not allow any commands
>to be edited in the console as does linux.

Use mysqlc rather than mysql.  Read this page first, you have to install
a library to make it work:

http://www.mysql.com/doc/W/i/Windows_running.html

>
>I decided that it would be easier to write a batch file to do some work but
>can't find out how to get mysql to process the batch file.  Issuing the
>mysql > batch file in dos mode wont work.

You might have better luck if you use "mysql < batch".  > sends the
output into your file, wiping it out.

>
>Any help appreciated as I'm getting sick and tired of entering long queries
>at the mysql prompt and then retyping the whole thing if I make a small
>syntax error.
>
>Stan Bordeaux
>Injury Prevention Policy Officer
>Public & Environmental Health Service
>1/34 Davey St
>Hobart 7000
>ph: (03)6233 3774
>fax: (03)6223 1163
>email: stan.bordeaux@stripped


-- 
Paul DuBois, paul@stripped
Thread
windoze and batch filesBordeaux Stan3 May
  • Re: windoze and batch filesryc3 May
  • Re: windoze and batch filesPaul DuBois3 May
  • Re: windoze and batch filesGerald R. Jensen3 May
  • RE: windoze and batch filesSander Pilon3 May
    • RE: windoze and batch filesWayne Kodie3 May