How to stop query in navicat

Method to stop Navicat query: Click the "Stop" button in the query editing window (shortcut key Ctrl F2). Click the "Stop" button at the bottom of the query results window. Select the connection being queried, right-click and select "Stop Execution". With the Query tab selected, right-click the query and select Stop.

How to stop Navicat query

The method to stop Navicat query is as follows:

In Stop the query in the query editing window

• Click the "Stop" button in the upper right corner of the query editing window, and the shortcut key is Ctrl F2.

Stop the query in the query results window

• Click the "Stop" button at the bottom of the query results window.

Stop the query in the connection window

• Select the connection that is executing the query, right-click and select "Stop Execution".

Stop the query in the main interface

• Select the "Query" tab, right-click the query being executed and select "Stop".

Note:

• Stopping the query will not save uncommitted transactions.
• If the query is running for a long time, it is recommended to use the "kill" command to terminate the query immediately.

Kill query command:

• In the connection window, enter the following command:

<code>KILL <query_id>;</code>

• Replace <query_id> with the ID of the query being executed.
• To get the query ID, select the Query tab in the connection window, then right-click on the query being executed and select Details. The query ID will be displayed in the Details window.

The above is the detailed content of How to stop query in navicat. For more information, please follow other related articles on the PHP Chinese website!