What I do is use the 'source' command. Now, I am assuming that you are
running under Win32 since you said "MSDOS hangs." Write the SQL command in
your favorite text edior and save. At the mySQL prompt enter the keyword
'source' and then drag&drop the filename unto the MSDOS window. Change the
'\' to '/' in the command line. Put the semicolon at the end, press ENTER,
and Voila' you have the command executed.
Example:
source C:/usr/bin/mysql/sql/updateALL.sql;
HTH
Will
-----Original Message-----
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 9:13 AM
To: Naintara Jain; Stefan Hinz; mysql
Subject: Re: editor
Dear Naintara,
>I don't really need a query-creator. If i use notepad, copy and paste
>doesn't seem to work -- MSDOS hangs. Do i need to make them into script
>files and then run?
I assume you run MySQL under Windows 9x. Here, the MySQL Monitor does
not supply a history list by default.
Simply start c:\mysql\bin\mysqlc.exe instead - and the history list is
there! :)
(Note: You will have to copy cygwinb19.dll to your windows/system
directory before using mysqlc.)
You can even type your statement with any editor (notepad etc.) and then
start MySQL in batch mode. This is how you do it:
1. Type the statements, each ended by a semicolon, something like this:
USE test;
CREATE TABLE test_table (testcol INT NOT NULL);
INSERT INTO test_table VALUES (1), (2), (3);
etc.
2. Save the file. For the next step, I assume you save it to
c:\mysql\bin
3. Start mysql.exe (not mysqlc.exe!) from the DOS command line, in batch
mode, like this:
mysql < the_file_i_typed_in_notepad.txt
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "Stefan Hinz" <[EMAIL PROTECTED]>; "mysql" <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 3:34 PM
Subject: RE: editor
Dear Stefan,
thanks for your input.
actually all i need to know is say i type in a long sql query and make a
typing error, is there any convenient way to retain the query and make
the
correction without having to re-type the entire query?
eg. when i work with sybase on linux, i simply use 'vi' within sybase
and
can correct the last query in memory. Even Oracle has an editor for
saving/editing queries and running them.
I don't really need a query-creator. If i use notepad, copy and paste
doesn't seem to work -- MSDOS hangs. Do i need to make them into script
files and then run?
regards,
-----Original Message-----
From: Stefan Hinz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 12:38 AM
To: Naintara Jain; mysql
Subject: Re: editor
Dear Naintara,
what about Notepad (the windows standard editor)?
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "Naintara Jain" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 7:02 PM
Subject: editor
> is there any editor available (eg vi on UNIX) that runs on MS-DOS to
make
> writing queries easier in MYSQL. I am a newbie.
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
