Visual Query Designer
and Editor for MySQL

When tables are joined, you can see and edit their conditions on the Joins tab. It will be easy to manage joins as they are presented as a tree in the tabbed editor. The join can have either a separate condition or a group of conditions, united with a logical operator. The groups of conditions are presented as the nodes of the tree. Each node accurately shows the type of the join and names of the tables, which are joined. When you expand a node, you can see join conditions. You can edit all join parameters (types of joins, conditions, or group of conditions, logical operators, etc.) in several clicks. One - to click the required parameter, others - to select the options from the appeared menu or a drop-down list, or enter the value manually. You can add or delete joins or their parameters even in one click. Use the plus button to add and the minus button to delete. For more flexibility, you can use the common Ctrl+C and Ctrl+V commands to copy and paste conditions.

To manage WHERE and HAVING clauses, use the corresponding tabs of the editor. They also present conditions as the compact tree. You can create either a separate condition or groups of conditions, which are displayed as tree nodes. To quickly do this, click the logical operator, marked with red, and select the required option from the menu that will appear. Use the same menu to change the type of logical operators group. To navigate between conditions and groups, use the up and down arrow keys. Use the left and right arrow keys to navigate between criteria operators and operands. To move conditions from one group to another, click the condition element and, holding the left mouse key, move it to the required place.

When you need to group retrieved data by some fields, specify them on the Group By tab. To add or delete fields to the list, use the arrow buttons in the middle of the tab. To change the columns order, use up and down arrow buttons. To sort data by fields, select them on the Order By tab just the same way. You see, the logic is the same, so you will intuitively understand what to do next.

The Data window offers a set of various modes for convenient viewing retrieved data. They are the following:

• Grid View
• Card View
• Paginal Mode
• Auto-search Mode
• Data Observer Mode
• Cached Updates Mode

By default, Grid View is selected, so you can see the query results in the grid. To optimize data overview, you can change columns' width using the Best Fit option from the right-click menu. For better understanding and analysis, you can group, sort, and filter your data. If you retrieved data from one table only, you can edit data right in the grid and apply changes. Use Append and Delete options from the right-click menu to add records to the table or delete them.

Card View is another good way of data presentation. It shows each data row as a card where the row number is placed as the card caption. Using this mode, you get accurately organized data, which is convenient for analysis and great-looking when printed.

Paginal Mode will suit you when retrieved data contains thousands or even more records. You can set a number of rows on the page to display the data in parts.

Auto-search Mode allows you to instantly find data in the columns. Click any field in the required column and type the first characters the required field contains. If you made a mistake when typing, press Backspace and type the string again. You will be automatically moved to the found field.

Cached Updates Mode can be used to control updates of any separate database object. When you turn on this mode for some object and begin changing its data, updates are stored locally on the client side, until you click the Apply Changes button. If you do not want to apply the changes, click the Cancel Changes button. When you close the Data window in Cached Updates Mode, you will cancel all changes made since the last Apply command.

When dealing with BLOB fields, open LOB Viewer window, which automatically detects the type of the content in this field and represents it as an image, text, rich text, or hex dump.

Choose Data export option to export retrieved data to 10 popular file formats (CSV, DBF, HTML, MS Access, MS Excel, ODBC, PDF, RTF, Text, and XML) with additional settings. Query Builder offers a convenient wizard to make export accurate and customizable. For example, while exporting data to MS Excel, you can choose separate colors for the text and background in table's header and rows, change border width and font settings, and preview the results.

Print your data just from the grid using the Print option from the shortcut menu. To print the diagram with the query elements, select the required section on the diagram and in the main menu click File→Print.