Home > Database > Mysql Tutorial > How to stop a running MYSQL statement on Navicat

How to stop a running MYSQL statement on Navicat

WBOY
Release: 2023-06-04 13:31:04
forward
2092 people have browsed it

    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:

    How to stop a running MYSQL statement on Navicat

    2. Use SQL mode to stop the running SQL

    (1) Find the running SQL ID

    Use show processlist to find:

    show processlist;
    Copy after login

    How to stop a running MYSQL statement on Navicat

    (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:

    How to stop a running MYSQL statement on Navicat

    The SQL statement was KILLed and the termination was successful!

    How to stop a running MYSQL statement on Navicat

    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!

    Related labels:
    source:yisu.com
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Popular Tutorials
    More>
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template