Making maximum use of query results
After your query is executed, you can see the retrieved data in the Data
window and, in case any errors occur during the execution, see the list of errors
in the Error List window. These windows are placed under the editor, so you
can control your query on all stages - from creation to execution. As you can execute
separate subqueries, as well as the main query, you can open the Data window
for each subquery.
Query Builder has concentrated all functionality that you would like to have at
your fingertips while managing query results.
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, 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 tables 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 - use it 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 right-click
menu. To print the diagram with the query elements, select the required section
on the diagram and in the top menu click File→Print.
The list of Query Builder's features can be continued. You can choose them to empower
creating and managing queries. Query Builder has become popular since it's been
implemented as part of dbForge Studio for MySQL and dbForge Fusion for MySQL.
Summary
Whether you are a newbie in building queries or a professional with solid expertise,
the industry offers a wide choice of full-featured IDEs, highly-tailored powerful
tools, or a variety of add-ins to meet your needs. You can decide in favor of any.
Query Builder is a reliable tool, which will assist you where you lack skills,
automate your routine tasks, and provide the desired opportunities to make maximum
use of query results. Using Query Builder, you will appreciate building queries,
as you will get a clear understanding what to do and how to do, so that your tedious
query creating will become easy and almost hands-free.