How to Pause a MySQL Query Process
The MySQL "pause" feature lets you stop and pause execution of a query statement running on the database. Use the pause feature in MySQL Query Browser when you want to stop and view the next statement set to execute in the query's SQL statements. The feature helps database developers debug MySQL statements, and view statement variable values during execution.
Instructions
-
-
1
Open the MySQL Query Browser software on your MySQL server database. Enter your username and password in the log-in window to log in to your database server.
-
2
Open the query editor in Query Browser. The browser opens an editor connected to the database. Type your MySQL statements in this window.
-
-
3
Open the query you want to debug. Click "Execute" to run the query statements. Click the "Pause" button to stop execution.
-
4
Click "Continue" to restart the process. The query statements execute from the point where you stopped execution.
-
1