MySQL Workbench 5.2 Querying Quick-Tour
May 27, 2009 – 12:48 pm by Michael G. ZinnerFor anybody interested in trying out our new MySQL Workbench 5.2 Alpha2 I have prepared a short Quick-Tour that will show you the most important steps to successfully use WB to query your databases.
Manage Your Connections
MySQL Workbench 5.2 introduces a new Home Page that makes it very easy to access all your Database Connections and EER Models. It features the Workbench Central Panel, the Database Connections Panel and the Model Files Panel.
In order to be able to connect to your MySQL server you have to create a new Database Connection so MySQL Workbench knows about your server instance. Follow the steps shown below to create your first Database Connection.
Click on the screen shot to see it at full size.
Connecting to and Working with the MySQL Server
Once you have created your connection, a new Connection Icon will appear on the Database Connections Panel. Double-click this icon to open a SQL Editor for this connection.The next screen-shot shows how to query the database.
Again, click on the image to see it at full size.
Apart from writing SQL statements in the editor, you can also load scripts via the tool bar buttons.
As you can see it is really straight forward to use the Database Connection management and the new Query Functionality inside of MySQL Workbench 5.2. The current Alpha2 is a very early release but it already shows off some of the potential the final WB 5.2 GA feature set release will offer.
Please give it a try and tell us which features you would like to see in the future. But please remember, this is an Alpha version, so do not work on critical production data.
Michael G. Zinner
9 Responses to “MySQL Workbench 5.2 Querying Quick-Tour”
the edit command is not feasible on tables with a lot of rows. the old querybrowser with editable selects was better. i hope you will bring that feature back or improve the edit command.
By gans1 on May 29, 2009
Will there be support for making connections to other database systems apart from MySQL (e.g. SQLite)?
By thenlich on May 29, 2009
gans1, good point. We just introduced that EDIT keyword as a workaround until we can detect wether a normal SELECT is editable or not (like we did in QB).
Please remember that this is still the 2nd Alpha release. There are lots of things still to be improved and added
By mzinner on May 29, 2009
Thanks for this.
I cannot connect because of a missing custom socket connection field allowing to connect mysql.sock in a different place than /tmp folder. The field is still in MySQL Tools in More options and works with MAMP. It’s a shame because wanted to try out your cool tool…
By davss on Jun 7, 2009
Support for other databases requires significant work and will probably
not be added anytime soon.
On the other hand, there is a user contributed Plugin that exports WB models as SQLite scripts: http://dev.mysql.com/workbench/?p=227
By akojima on Jun 10, 2009
davss: that was a bug, it has been fixed and will settable be in the next release. However, since we’re working on finishing up the 5.1 branch, it will take a while until a 5.2 release is made.
But there is a workaround:
1- locate mysql_rdbms_info.xml from the Workbench installation and open it in some text editor
2- search for id=”com.mysql.rdbms.mysql.driver.native.param9″
3- copy/paste the whole entry starting from that line up to the matching </value> tag, to a new entry right after that one
4- change the id of the duplicated entry from …param9 to param10
By akojima on Jun 10, 2009
Hi,
I tested this version, which is really an excellent work. But I think there are some bugs to be corrected before add new features. The data model editor is very slow despite my system configuration (dual core, 2Go RAM, Windows). The data are not updated on others table when I rename a column for example. If I redefine a relation the tables associated are not updated.
To finish the text on tab query editor is not displayed correctly.
cheers.
By kikou on Jun 11, 2009
Please, make possible to work on database scheme in team. Now it’s almost impossible. We use svn, and only one person can edit shcheme at the moment. If a conflict occupies – we need to change one version with hands.
It would be greatful, if we’ll be possible to make diff/merge schemes.
We use OSS version, but would buy SE, as many other people waiting for some possibility to work in team with workbench.
Thank you for this program.
By deniso on Jun 29, 2009
deniso, yes, we are planning a Team Edition for MySQL Workbench.
We will offer a merge-GUI that will allow you to resolve the conflicts you get in your version control system.
But this will not be part of WB 5.2 as there are even more people requesting querying and admin capabilities and we want to get that done quickly.
Then we can look at the more complex issues like a Team Edition.
By mzinner on Jun 29, 2009