7.1 Visual SQL Editor

7.1.1 SQL Query Window
7.1.2 SQL Query Window Toolbar
7.1.3 Query and Edit Menus
7.1.4 Results Window
7.1.5 SQL Snippets tab
7.1.6 Context Sensitive Help
7.1.7 Output History Panel
7.1.8 Table Data Search Panel
7.1.9 Export a Result Set
7.1.10 Tutorial: Adding Data
7.1.11 The MySQL Table Editor
7.1.12 Code Generation Overview

The visual SQL Editor lets you build, edit and run queries, create and edit data, and view and export results. Color syntax highlighting, context sensitive help and auto-complete helps write and debug SQL statements. The integrated EXPLAIN plans provide data to help optimize the your queries.

Figure 7.1 SQL Editor GUI

SQL Editor GUI

The following sections describe how to use the visual SQL editor.