469,088 Members | 1,273 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

Correcting queries

In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?
Jul 23 '05 #1
2 1025
James Walker wrote:
In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?


It depends on what Client tool you are using to connect to the db
server. I use the MySQL Query Browser that is GPL (I believe) from
MySQL.com for things like this.

randelld
Jul 23 '05 #2
"James Walker" <wa*******@comcast.net> wrote in message
news:Wd********************@comcast.com...
In Oracle there is a way to correct any mistakes in a query, by simply
entering the edit command. And from there, a text editor is opened, to
allow the corrections to be made to the query. This eleminates having
to retype the whole query. Is this possible in MySQL?


Possible? It's essential!. It depends upon what you use to communicate with
MySQL. The simplest setup would be to open up ones favorite editor in one
window while simultaneously holding open a second window where you can
execute the script and view results (or errors!). I happen to like being
able to choose my own text editor.

Repeat
Edit
Save
Execute
Until Success

If that sounds complex (it's not!) you can go for one of several integrated
GUI utilities out there. Simple and free is the MySQL Control Center
[MySQLCC] that you can download from www.mysql.com. It is available in both
Windows and Linux/Unix flavors. Using it for making queries - you get a
text editing window (pane) for your SQL, a results window, and an
error/message window. I expect it would look a lot like your Oracle
utility.

but - Probably better :-)
Thomas Bartkus
Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by vv1 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.