Query Results

You can execute your queries across any server. Simply select the target connection, database, and/or schema from the drop-down list on the toolbar, and then click Run.

If the statement is correct and is supposed to return data, the Result tab will open displaying the returned data in a grid. If an error occurs, execution stops and an appropriate error message is displayed.

Execution Options

You are not limited to running the entire query at once. You can execute specific portions of your code:

• Run Selected - Highlight the specific code in the editor and click Run Selected.

• Run Current Statement - Position your cursor within the desired statement, click the down arrow next to the Run button, and select Run Current Statement.

Result Tab Toolbar

The toolbar provides the following functions:

Button	Description
MySQL, Oracle, PostgreSQL, SQLite, SQL Server, MariaDB, Snowflake
Cell Editor	Activate the cell editors for viewing and editing data.
Data Profiling	Profile the data in the query.
Export	Export the result of the query.
MongoDB
Cell Editor	Activate the cell editors for viewing and editing data.
Type Color	[Grid View] Use the specified type color set on the Type Color pane to highlight cells.
Export	Export the result of the query.
Redis
Editor	Activate the editor for viewing and editing data.
Common
Pin	Pin the tab.

Query Parameters

Navicat supports the use of parameters inside the query text, allowing you to dynamically add variable values each time you run a query. The parameter should appear as an identifier with $ at its beginning, quote with [ ], e.g. [$any_name].

When you execute the query, an Input Parameter dialog will prompt you to enter the desired data. You can check the Raw Mode option to pass the inputted values directly to the query without quotation marks.

Adjust Result Position

In Navicat, you have the flexibility to configure how query results are displayed. You can choose to show the query results on an entire page, on the right side of the editor, or at the bottom of the editor. This allows you to adapt the display layout based on your specific needs and preferences during data analysis and exploration in Navicat. To change the result position, use the or icon located in the upper right corner, or access the View -> Result menu.

Pin Query Result (Available only in Enterprise and Standard Edition)

Existing result tabs are removed when you re-execute the query. You can pin a result tab so that it remains visible after re-executing the query. Simply click Pin and its contents will not be cleared the next time you execute it.

When you pin a tab, it will display a pin icon and automatically moves towards the left side of the tab bar. All pinned tabs appear from left to right in the order you pinned. Hover over a pinned tab will show its execution time and the query. You can pin any number of results and quickly see what's pinned and what's not pinned. Simply click Unpin to unpin a tab.

Custom Tab Name

To customize the names of the result tabs, simply add -- NAME:tab_name or /*NAME:tab_name*/, or // NAME:tab_name (for Redis) before each statement in the editor.

Show Query Profiling and Status

To show the query profiling and status when running the query, simply choose View -> Show Query Profiling and Status and click Run on the toolbar.

The Query Profiling tab under the Result tab displays the query profiling: Table lock, System lock, Statistic, etc.

The Status tab displays the query status: Bytes received, Bytes sent, etc.