MySQL stored procedure debugging tool-dbForgeStudioforMySQL tool official website address: http://www.devart.com/dbforge/mysql/studio/
For SQL applications with many and complex stored procedures, to make all MySQL stored procedures and functions run normally in a short time, if you can find a better debugging tool, you can get twice the result with half the effort. here we will introduce dbForge Studio for MySQL. 1. First, it indicates that dbForge Studio for MySQL is charged for the version with the stored procedure debugging function, but there is a 30-day call period, I think it is enough to meet your requirements. 2. the installation part is omitted. download and install the package directly on the official website without dependency packages. 3. debug the stored procedure. we recommend that you debug the package in the testing environment. 3.1 generate Debugging information for the stored procedure: Right-click the process to be debugged -- "Debug" -- "Compile for Debugging ', and perform the following 3.2 operations to set breakpoints for the stored procedure: open the Stored Procedure Code. you can double-click the row where you want to set the breakpoint to 3.3 debug the stored procedure, perform it in one step, and view the value of each variable. Right-click the stored procedure --- "Debug" -- "Step Into". for example, after selecting "Stop Into", if your stored procedure has parameters, enter the parameter value as prompted in the pop-up form, if not, the stored procedure is not directly run. the stored procedure starts from "begin", and then click "step over" (F10) next to the desired one. Check the variable value: Right-click the variable and select "Add Wath". The variable will appear in the View area of "Watches". if you run the variable value in one step, then you can see it, so that you can debug whether the variable value is correct, whether there is an error, or the number of cycles. Debugging is similar to Eclipse. a rough description is provided to help you find it later. if you have never used it, you can follow the steps to learn how to use it.
