Stan:
We do it every day.
Use notepad (or whatever text editor you have available) to create the query
file and save it a folder.
Make sure C:\MYSQL\BIN is in your path, and open a DOS prompt. CD\ to the
folder with the query file, and run it with a command line like:
mysql -u{username} -p {dbname}<{queryfile.txt}
...i.e.:
mysql -ugerald -p database<databasequery.txt
Supply the password when prompted to enter it.
You might also want to try one of the free GUI utilities, like MySQLFront
(http://www.mysqlfront.de). I happen to like MySQLFront because it has a
query editor, table/column editor, etc.
Gerald Jensen
----- Original Message -----
From: "Bordeaux Stan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 7:23 PM
Subject: windoze and batch files
> 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.
>
> 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.
>
> 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: [EMAIL PROTECTED]
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
