Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Brazil: +55 11 5189-1097
MySQL Workbench gives developers a complete set of visual tools to create, edit, and manage SQL queries, database connections and objects.
The visual SQL Editor lets developers build, edit and run queries, create and edit data, and view and export results. Color syntax highlighting helps writing and debugging SQL statements. And EXPLAIN plans can easily be gathered to help optimize queries.
Plus, multiple queries can be executed simultaneously and results can be viewed on individual Tabs in the Results Window. The Table Editor makes it easy to edit data and commit changes using a simple grid format. The export facility allows developers to export results data to common formats.
The History Panel provides complete session history of queries and statements showing what queries were run and when. Developers can easily retrieve, review, re-run, append or modify previously executed SQL statement.
In addition, the SQL Snippet panel lets developers save and easily reuse common Selects, DML and DDL code. The most common queries can be placed in snippets so that they can quickly be retrieved and re-used later by simply double clicking in the snippet list.
The Database Connections Panel and Connections Wizard enables developers to create, organize, and manage database connections. Advanced users can use the Manage Connections dialog to enter connection parameters like IP address, port, username, and password.
The Object Browser enables developers to easily navigate database schemas and objects. DBAs can visually select tables and fields to query, edit tables, create new tables and databases, and drop tables and databases.