MySQL Workbench: SQL Editor
With the release of MySQL Workbench 5.2 we added something that forms the basis for a major feature set and is the first not directly design-related addition: a feature rich and powerful editor for SQL scripts. As we mentioned in our MySQL Workbench roadmap this will grow to a full SQL IDE. Based on the experiences we collected from our highly popular MySQL Query Browser we will implement all those useful features into MySQL Workbench and add some cool ones too. The ultimate goal is to give Workbench users a tool at hand which provides a unique and convenient surface that combines DB design and “bread-and-butter” DB work in a productive and attractive, yet easy to use fashion. The SQL editor is based on the great open source editor control Scintilla. We not only used this fine piece of software but also contributed to it with what we developed for our favorite MySQL tool.
SQL Editor Features
- Single and Multi Statement Execution, including detailed execution log and query history. More than one connection at a time can be established and used.
- Embedded resultsets, with a splittable view to allow for optimal work area.
- Dynamic Error Parsing while typing, not only for correct identifier syntax but also full MySQL syntax.
- Convenience features, which simply make life easier. This includes quick zoom-in and -out for large text (use Cmd + scroll wheel, ctrl + wheel for non-Mac platforms), loading and saving from/to files, collapsible editor parts (query and result set area).
