[JBB]

Mostly to be able to execute/develop scripts on the fly, also improve the text output ( so we are not limited to 80 cols, like in the command prompt ).

The command line also comes with an editor (check screenshots ) which really comes in handy for creating scripts. We are not limited to one query result in the command line window, we can scroll back up and view our history. We can also execute our old commands by pressing up on the keypad….it's basically the same command line of but with nice features / improvements

As for the query builder, what's great in pl sql , it automatically detects if there's a relationship between two tables….we are giving the option to join the keys or not. I haven't seen a mysql gui do this yet.

Depending where the query builder was called from…it will generate the sql for us.

If it was called from the command line dialog, it will execute the sql…if it was called from the editor, it pastes the code in the editor.

[JBB]

Hi,

i've been looking and testing different kinds of mysql gui/ide apps these past few days.

I have a final project to do @ college and we can use any type techonologies/tools as we wish. I decided to do a web application with mysql. The only experience i have managing mysql databases is with phpmyadmin.

I had the pleasure working with a great IDE program called pl/sql developper (http://www.allroundautomations.com/) with Oracle during the past 2 years.

I tested about 10 applications so far, and i would put sqlyog in the top 3. But not of them has come close to pl/sql developper.

i like sqlyog simply because it's one of the fastest apps i've used so far. It has some good features, but lacks a few i've been spoiled to 🙂

I would really like to see :

• a command line window ( like in pl/sql dev )
• autocomplete ??
• query builder ( like in pl/sql dev )

the other apps that i like for the moment are : navicat, EMS MySQL Manager, Aqua Data Studio and Toad Mysql

[Author]

Posts