Create a query

1. In the Database Window , click the Query tab
2. To create a new query, click New Query button in the Database Window

Open or run a query

1. In the Database Window , click the Query tab
   
2. Select the query that you want to open in the Database Window
   
3. To open the query in Data View, click Open Query button in the Database Window
   
4. To open the query in Design View, click Design Query button in the Database Window
   
5. To run the query, press Run button.
   To run the selected query, control-click on the SQL panel and select Run selected.
   To run the query starts from a specific point, control-click on the SQL panel and select Run Statement from here.

Delete a query

1. In the Database Window , click the Query tab
   
2. Select the query that you want to delete, click Delete Query button in the Database Window

Save a query

Navicat keep your queries separately for each database so that you will always see your queries that is specific to a database in the Database Window. See Connect to MySQL, Setting up Connections for more information on the queries saving locations.

Parameters Query

To implement a Parameters Query, employ the syntax as [$variable].
For example: Select * from table_A where id= [$id]
An Input Box will pop up asking for specifying the search condition when the Query is run.

Load SQL file (.sql extension)

1. In the Database Window , click the Query tab
   
2. click New Query button in the Database Window
   
3. click to load a sql file. The SQL statements inside the file will be shown in SQL window.
   You can click Run button to execute the statements.

Log History

In Navicat version 5.3, log history is available to keep track on what actions have been performed in Navicat.

The log history will store actions performed in a session of Navicat.
The log file is stored in a file named QueryExec.log which is located in the Directory which you installed your Navicat.