MySQL Workbench: SQL Development

MySQL Workbench gives developers a complete set of visual tools to create, edit, and manage SQL queries, database connections and objects.




Visual SQL Editor

The visual SQL Editor gives designers a chance to manufacture, alter and run questions, make and alter information, and view and fare comes about. Shading language structure highlighting, setting delicate help and auto-finish helps in composing and troubleshooting SQL proclamations. What's more, EXPLAIN arrangements can undoubtedly be accumulated to improve questions. The SQL Editor gives:

Table Editor - effortlessly alter information and submit changes utilizing a basic network arrange.

Comes about Window - execute different questions at the same time and view content results, picture and spatial perspectives, and inquiry execution measurements on individual tabs.

SQL Snippet Panel - spare and effectively reuse basic Selects, DML and DDL code.

History Panel - see finish session history of inquiries and proclamations demonstrating what questions were run and when. Effectively recover, audit, re-run, annex or adjust beforehand executed SQL explanations.

Table Data Search Panel - discover information over a whole database by demonstrating content pursuit on any number of tables and diagrams, indicating columns coordinating a given example.

Send out Results - trade comes about information to regular configurations including CSV, HTML, and XML.

Question Management

The Object Browser empowers engineers to effortlessly explore database compositions and articles. DBAs can outwardly choose tables and fields to question, alter tables, make new tables and databases, and drop tables and databases.

Blueprint Inspector - Leverage a suite of point by point matrices on all articles in their database compositions to view, sort, and break down different subtle elements and measurements. From inside Schema controller designers can undoubtedly conjure table upkeep operations, for example, ANALYZE and OPTIMIZE TABLE.


Protest Browser - Easily explore, investigate, and perform activities on database objects (tables, sees, triggers, and so forth.)

Protest Editor - Easily alter, make or erase database objects (tables, sees, triggers, and so on.)

Association Management

The Database Connections Panel and Connections Wizard empowers engineers to make, arrange, and oversee standard database associations, including MySQL Fabric. Propelled clients can utilize the Manage Connections exchange to enter association parameters like IP address, port, username, and secret key, and in addition effortlessly make secure remote associations by means of ssh.