Online Documentation for SQL Manager for MySQL

Using Navigation bar and Toolbar

The Navigation bar and Toolbar provide quick access to tools implemented in Query Builder.

The Navigation bar of Query Builder allows you to:

Database group

select a database for the query

General group

execute the current query

clear the query

create a view

view MySQL reference

configure Query Builder using the Query Builder Options page of the Environment Options dialog

restore the default size and position of the builder window

set printing options using the Print Setup dialog

preview the diagram

Objects group

browse objects of the database; you can also add tables and views to the diagram using drag-and-drop operations

Depending on the current tab selection, the Navigation bar expands to one or more additional panes with tab-specific actions that can be useful for working with queries:

Visual Builder group

load a diagram from a *.vqb file using the Open diagram dialog

save the diagram to a *.vqb file using the Save diagram as... dialog

Edit group

load a query from an *.sql file using the Open SQL File dialog

save the query to an *.sql file

Data Management group

commit transaction

rollback transaction

export the returned dataset using Export Data Wizard

export the returned dataset as SQL Script using the Export as SQL Script wizard

save data to a file

export data as PHP page

Items of the Navigation bar are also available on the ToolBar of Query Builder. To enable the toolbar, open the Environment Options dialog, proceed to the Windows section there and select Toolbar (if you need the toolbar only) or Both (if you need both the toolbar and the Navigation bar) in the Bar style for child forms group.