MySQL Workbench 5.2.36 is now out and brings a lot of improvements across the board, with special focus on the Query Editor. We’ll cover some of that here:
Redesigned Query Editor
- The log of executed commands and server responses is now always visible while resultset grids and the query editor can be resized according to your needs. Resultsets are also grouped in the same tab as the query editor that generated them.
- SELECT queries are now analyzed as in the old MySQL Query Browser tool and, if possible, its resultset can be edited in the grid. If the resultset cannot be edited, you can place the mouse over the ReadOnly label and view the reason.
- Improved snippets manager and editor, allows having snippets list always at hand, while editing can be done without disrupting work on the main query area.
- Editor state is now properly saved between sessions. Sidebar sizes, the last selected schema and other state information is now properly remembered between sessions.
- Script and resultset tabs can be reordered.
- Keyboard navigation of resultsets has been fixed to properly handle Tab key navigation in all platforms.
- The schema tree will now work with multiple selections, allowing the same action to be performed with more than one object at a time. You can select the columns to appear in a SELECT statement.
- A filter box was added to the live schema tree, allowing you to restrict the number of visible items in the tree to what you’re interested in.
- The schema tree was expanded to show more information about objects. In addition to schemas, tables, column, views and routines it also displays information about triggers, indexes and foreign keys. The object information box has been improved.
- Export recordsets to Excel, JSON and XML files that match the format used by MySQL. The export code has also been revamped to make writing custom export formats easier, which will be explained in a future post.
The Administrator was also improved in the following areas:
- Server Start and Shutdown page was updated to include server error log output
- The Log browser support was improved to work with log files, in addition to log tables, when managing local and remote servers.
- Export/Import layout was cleaned up and is now roomier and less cluttered.
The focus of this release was on the SQL Editor, so there isn’t much new here. But heavy modeling users on Linux and Mac should be happy to know that the catalog tree has been finally fixed to stop scrolling back to the top.
We’re still working hard on adding and finishing more improvements to the major features we already have in MySQL Workbench, to make it the best and easiest to use database tool; but we think this is a good step forward.