Correcting queries

[James Walker]

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?

[Randell D.]

Re: Correcting queries

James Walker wrote:
[color=blue]
> 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?[/color]

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

[Thomas Bartkus]

Re: Correcting queries

"James Walker" <walkerj72@comc ast.net> wrote in message
news:Wd2dnQMT-PyNiI_fRVn-sg@comcast.com. ..[color=blue]
> 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?[/color]

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