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
