How to stop a running MYSQL statement on Navicat

1. Graphically stop SQL

Run an extremely long SQL and find that there is no result. Click "Stop##" in the picture below. #" button, but unfortunately it has no effect and cannot be stopped:

2. Use SQL mode to stop the running SQL

(1) Find the running SQL ID

Use show processlist to find:

show processlist；

(2) Run the kill command to kill SQL

Known from the previous step The ID of SQL is 14205. Run the kill command to terminate:

The SQL statement was KILLed and the termination was successful!

The above is the detailed content of How to stop a running MYSQL statement on Navicat. For more information, please follow other related articles on the PHP Chinese website!