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
Re: editor
You can try FreeMascon. It's a windows grafical UI client for MySQL. There you can find a query editor that even highlights syntax. And it's free. download at www.scibit.com HTH, Tadej - Original Message - From: Naintara Jain [EMAIL PROTECTED] To: Stefan Hinz [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Wednesday, August 08, 2001 2: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
RE: editor
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 dragdrop 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
RE: editor
Have a look at urSQL -- http://www.urbanresearch.com/ursql/urquery.php urSQL is a query editor (much like a text editor with database/query support and SQL syntax highlighting). It has the capability to connect directly to your server and submit the query. The History feature keeps track of each query that is submitted to the database. You also have the option of saving, opening, and editing existing queries. On Wed, 8 Aug 2001, Naintara Jain wrote: 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? - 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
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
Re: editor
Yes, have a look at urSQL (http://www.urbanresearch.com/ursql). You may also want to have a look at MyODBC and the various clients available from mysql.com, including mysqlgui. On Mon, 6 Aug 2001, Naintara Jain wrote: 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
Re: editor
Ick !!! This question had come up on the list about 2 weeks ago... I like: WinVI (I know that the Emacs lovers will respond soon) at: http://www.winvi.de/en/ For other versions and 'ports' of VI, see The VI Lovers Homepage at: http://www.thomer.com/thomer/vi/vi.html - Original Message - From: Stefan Hinz [EMAIL PROTECTED] To: Naintara Jain [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Monday, August 06, 2001 12:08 PM 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