Navicat MySQL provides a useful tool called Visual Builder for building queries visually. It allows you to create and edit queries without knowledge of SQL. The database objects are displayed in left panel. Whereas in the right panel, it is divided into two portions: the upper Graphical View, and the lower Syntax View.

To open a query in the visual builder (see Edit Query for details).

Note: Visual Builder supports SELECT statement only. Use Query Editor for creating complex queries.

• Working with Diagram Area
• Setting Field Association
• Setting Output Fields
• Setting Criteria
• Setting Grouping Criteria
• Setting Sorting Criteria
• Setting Limit Criteria